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

Hello emailcurry (AT) gmail (DOT) 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

Hello Allan, thanks for the reply.

The flatfile looks something like
jonny lang!PV90210!2-3&2&3!!xxx!

I want to separate the fields so that in the database table, jonny lang
will be in column 1, PV90210 will be in column 2, 2-3&2&3 will be
calculated and the value returned into column 3, nothing in column 4,
xxx in column 5.

What is a Script Component? How do I use it? I am quite new in using
SSIS, if you have any good site that gives tutorials in using script
component that would be great. Thanks in advance!!

Cheers,
curry

Allan Mitchell wrote: