Post reply

Creating Header and Footers in export files

  • October 11, 2007 at 5:40 am

    #153886

    Hi

    I have a simple table with 4 columns that I need to export to a text file using SSIS - no problem there. But I also want to create the file with a header and footer. The header contains some static data and the date and the footer contains the number of records.

    In DTS I had some ActiveX scripts to export the header, data, and footer to 3 separate text files then used more scripts to append the 3 of them together. Failrly chunky I know but it works. I'm thinking there must be a much nicer way to do this in SSIS but I'm not sure what.

    cheers

  • October 12, 2007 at 6:32 pm

    #741762

    Hi - No I don't think so. What I see are 3 related tasks in the control flow. The middle one is the data flow that appends to file created by first task - A script task but you get to write it in vb.net - that writes the header. The 3rd task is also a script task; it appends the footer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply