Need to add an EOF marker to a Tab delimted text file being exported from SQL using DTS
Posted on 2008-10-08
I am VERY new to SQL and DTS. I have created a SQL statement that selects the data I need and I have figured out how to use the DTS Export wizard to create a tab delimited file. However, I need to add an EOF marker to the end of the destination text file. I also need to name the destinatiion file dynamically based on the date. Can you help me with some very detailed instructions on how to do this?