Multiple record type/length file

Multiple record type/length file

Post by bigbrorp » Fri, 17 Nov 2006 00:58:55

Hi -

I'm trying to import a file that has multiple record types in random
order into various tables.
For example:
Record Type A
Record Type B
Record Type A
Record Type C

Each type has different fields and is of a different length, and
obviously requires different logic to parse and insert into an
appropriate table.

In the past I had parsed out each record type into separate files using
Perl and then passed it into DTS. Has SSIS implemented something that
would allow me to do this operation w/o Perl? If so, how?