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 |
|
gaitchis
Starting Member
5 Posts |
 Posted - 2007-04-16 : 19:19:16
|
| Hi I was wondering if there is a way to insert a parameter into the export filename for a DTS package.My DTS package takes a parameter YEAR which is used in the query from the DB and therefore would like the results to be separated by that parameter as well.e.g the export file would be something like C:\MYFILE_[YEAR].txt |
|
|
craig79
Starting Member
33 Posts |
Posted - 2007-04-18 : 02:08:59
|
| U need to make use of a global variable to assign a filename. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-18 : 02:59:12
|
| or use an ActiveX Script task... |
|
|
|
gaitchis
Starting Member
5 Posts |
Posted - 2007-04-18 : 19:35:21
|
| Thanks guys, got it all working now. I have a new problem that I will start a new post though. |
|
|
|
|
|
|
Paramter for Filename in DTS Package export