Alvin Ramard (8/26/2014)
I would then use a script task to create a new file in which I would insert the Header, followed by the content of the file mentioned above, followed by the footer. The original flatfile can now be deleted.
Or just modify the existing flat file.
There are plenty of scripts on the web that show you how to add a line to the start or end of a flat file.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP