Multiple record type/length file

#1

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?

Thanks

#2

Hello bigbrorpi (AT) gmail (DOT) com,

This article may give you some ideas

http://www.sqlis.com/default.aspx?54

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

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?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Multiple record type/length file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Multiple record type/length file - 11-15-2006 , 09:58 AM

Re: Multiple record type/length file - 11-15-2006 , 01:24 PM