Hi there...
Imagine that I need a comment in the beggining and the end of each
table records. And my records come in blocks from different tables.
How to insert it?
Thanks!

Example:

*TABLE1* (Line with the comment)
1,2,3
2,3,4
*EOF*

*TABLE2*
1,2,3,4
2,3,4,5
*EOF*

Thanks again...

This is a non-uniform file format and for these it is best to write a custom
parser in VB.NET using Script Component in the Data Flow Task.

If the number of tables is fixed in a file, then you just create multiple
outputs in the Script Component and add rows to appropriate outputs as you
parse them.

If on the other hand the names and number of tables in the file are not
known in advance, it gets more complicated. Basically you need to write a
program that parses the file, breaks it up in smaller chunks and creates an
in-memory DTS package through our object model to load each of those files.

-Sergei

--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote