Hi All, I'm looking for some help on SSIS packages. Following is my problem. I need to generate a flat file with the header and footer information and the flat file would be in the following format File format: Note: Sequence number in the file name must match with the header information(001) Row Count(3), With a footer 'END' ABCD001 3 29. 51116 2903.14 END File name: XYZ001.txt Note: notice digit 001 in both header and filename. Could any one please let me know how can I handle the following situations using SSIS packages. How to have row count in the header information. How to make sure the digit in header information matches with sequence number of the flat file. How can I generate the flat file dynamically with a sequence number appended.

Any help would be greatly appreciated. Thanks in advance, -Amith Vemuganti.

More Ssis Create Flat File Header videos. I have a ssis package scheduled hourly and that package produces a flat file (text file) each time. Is there a way to generate a header for each of those flat file. Tabac Ajja Rouge more.

Hi Dinesh, Thanks for the reply. The sequence number is basically to uniquely identify the file if multiple files have to be generated, because the string to which the digit is appended would be common for all the files.

I'm also not sure why the Header information should be in that format, its a requirement given to me. I could find a solution by appending date and timestamp to the first part of the header information and file name. I have used a variable and concatinated the timestamp to the basic string.

For Example, The first part of Header would be ABC3546 and the filename would be XYZ3546. The Row Count in the Header section is also achieved using Execute SQL Task component and a variable in the control flow. Now my question is, How do we add footer to the file using SSIS. Any response would be appreciated. Thanks, Amith. You can't post new topics. Faketaxi Ava 2013 here. You can't post topic replies.

You can't post new polls. You can't post replies to polls. You can't edit your own topics. You can't delete your own topics. You can't edit other topics.

You can't delete other topics. You can't edit your own posts.

You can't edit other posts. You can't delete your own posts. You can't delete other posts. You can't post events. You can't edit your own events.

You can't edit other events. You can't delete your own events. You can't delete other events. You can't send private messages. You can't send emails. You can read topics.

You can't vote in polls. You can't upload attachments. You can download attachments.

You can't post HTML code. You can't edit HTML code.

You can't post IFCode. You can't post JavaScript. You can post emoticons. You can't post or upload images.