Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Datetime stamp in the output filename of a DTS job

Author  Topic  Eazy Starting Member 1 Post Posted - 2007-09-14 : 02:47:08 I am using DTS to write data out from sql server table to a Flat file output. I have to add datetime to the filename (filename_yyyymmdd_hhmiss.txt) and put this filename in each record of the flat file. How can I do that ? Thanks