Home Forums SQL Server 2005 SQL Server 2005 Integration Services Creating Header AND Footer to a flat file destination file RE: Creating Header AND Footer to a flat file destination file

  • February 15, 2011 at 6:46 pm

    #1287414

    i have a job that is reverse of this topic but involves parsing out a ragged flat file details from the header and footer. there are two headers, two details, two footers.

    header1=Header000

    detail data

    footer1=Trlr 1111 records

    header2=Header000

    detail data

    footer2=Trlr 2222 records.

    How can I get the details into a Sql Table without the header and footer. The row delimited is crlf with no text qualifyer. I am having difficulty getting this to work. Any help appreciated.