Quick question about SSIS

microsoft.public.sqlserver.tools

18 Feb 2007 11:48 PM

Mike C#

Hi all,

Just starting to play with SSIS. Is there a simple way with SSIS to import
a flat file in a format like this?

HDR|2 <-- "Header" with # of groups
GRP|1|2 <-- "Group" with group number and # of detail lines
DTL|1|Detail Item 1|3847593 <-- Detail lines
DTL|2|Detail Item 2|9283493
GFT|1|2 <-- "Group" footer
GRP|2|1
DTL|1|Detail Item 3|8734564
GFT|2|1
FTR|2 <-- File "footer"

Thanks