> Hello everyone,
>
> I'm a beginner in SSIS and DTS stuff. I have tried to make a package
> to
> - create flat file by executing a process
> - port it to data flow control where it delimits it and sents it to a
> database through oleDB connection.
> I'm using SQL Server 2005
> Now I want to add on to this process. Basically I want to,
> 1. get flatfile from directory
> 2. delimits it
> 3. as soon as it delimits the fields, manipulate them (run a custom
> program to do complicated calculation )
> 4. then port 'some' fields from flatfile, along with the new
> calculation into a database
> Question: Is it possible to generate a text file as soon as it
> delimits
> the field? I'm stuck going from step 2 to step 4.
> Any help would be appreciated. Thanks!
> -curry
>

Allan Mitchell wrote:
> Hello emailcurry@gmail.com,
>
>
> I am not sure what you mean "delimits it"?
>
> How is the flat file structured?
>
> You could write a custom component or use the Script Component as a source
> to write your own Source adapter to handle the format.
>
> You could fire off a process which does the calculations yes but you will
> need to break things apart with workflow.
>
>
> Can you perform these calcs in SSIS ? You could use the Script component
> as a transform - this may be useful.
>
>
> Allan
>