DTS Package - Rename destination .txt file.

[DBAchick]

I have created a DTS package that makes one connection and creats 7 .txt files based on different select statements. Each .txt destination file needs to have a path and file name assigned (General Tab on Properties of Text Destination.)

I want to be able to manipulate (before or after creation) the name of that file to include the current date. So instead of just \\server\share\directory\filename.txt, I want the path to be \\server\share\directory\filename20020328.txt.

Is there an easy way to do this?

Any suggestions are helpful!

 

[bperry]

Looks like you want to dynamically determine the name of the text file. I dunno if that's possible.
But Wrox has a good book called 'Professional SQL 2000 DTS'. If you had access to that, perhaps there's an answer in there.

Sorry, not much help.
bp

 

[bperry]

Found this url. Seems like a good place to start.

http://www.swynk.com/friends/green/textfile.asp

rgrds etc
brian perry

 

[DBAchick]

Excellent suggestions! Thank you both for your assistance!

 

[tlbroadbent]

The FAQs at Tek-Tips are often helpful. Try the following for example.

faq183-962: Where can I find more DTS information and samples?



Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.