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.
| Author |
Topic |
|
Rekha
Starting Member
14 Posts |
 Posted - 2008-06-30 : 09:07:00
|
| Hi,I have created a DTS where SQL server is source and text file destination.I need to change the name of text file for eg:If I run DTS today, the filename should be poet_2008_06_30.txt.Next day if I run the DTS it should be poet_2008_07_01.txt.Please let me know how should I change the file name dynamically.Thanks in advance!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-30 : 10:43:07
|
| You can do this by means of a vraiable. Add a global variable in DTS and set it to take current date value. Now add a dynamic properties task and put an expression for filename property of text file to take name as 'poet_' + value from variable. |
 |
|
|
ssexton
Starting Member
1 Post |
Posted - 2008-07-22 : 11:08:14
|
| Hi Could you explain this further? I'm having a similar issue. I have a DTS global variable that sets the location of the folder. And I have a global variable that has the dynamically changing file name that I want it to write to. What I'm unsure of is how to set the text file destination to = Folder + filename.Any hlep greatly appreciated. |
|
|
|
|
|
|
Change name of text file destination