dixiebp
asked on
Need to add an EOF marker to a Tab delimted text file being exported from SQL using DTS
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?
Thanks, DixieBP
Thanks, DixieBP
ASKER
Thank you.....the file naming now works. Do you know of a way too add an EOF marker after the last line of data in the text file?
>>Do you know of a way too add an EOF marker after the last line of data in the text file?<<
Again, any reason you have to do that? An EOF character is very rarely needed and has not been needed since mid-80's. If you still want to do it, than you will have to define what you mean by EOF in ASCII. CHAR(26) perhaps?
Again, any reason you have to do that? An EOF character is very rarely needed and has not been needed since mid-80's. If you still want to do it, than you will have to define what you mean by EOF in ASCII. CHAR(26) perhaps?
ASKER
We are sending the file to a company that uploads it into their system. They require some type of EOF marker to they know they have received a complete file. It can literally be the text "EOF" after the last line of data in the file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any reason why? And if so define EOF in ASCII
>>I also need to name the destinatiion file dynamically based on the date. <<
See here:
How can I change the filename for a text file connection?
http://www.sqldts.com/200.aspx