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 |
|
Maquis
Starting Member
25 Posts |
 Posted - 2004-02-13 : 09:03:09
|
| I have a DTS package that runs a SQL query to create output that is inserted into an Excel spreadsheet. I have one global variable that I use for the output filename in an ActiveX script. I need another global variable to use for a value in a where clause to create multiple spreadsheets. I would like to utilize dtsrun with the /A parameter to pass the multiple values, but I'm not sure how to use the global variable in the SQL query inside the DTS package. Anyone have any pointers? Thanks. |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-02-13 : 09:54:19
|
| Have a look at the following site:http://www.sqldts.com/ |
 |
|
|
Maquis
Starting Member
25 Posts |
Posted - 2004-02-13 : 11:42:24
|
| Thanks, I've got it nailed - appreciate the help. |
|
|
|
|
|
|
utilizing global variables within DTS