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 |
|
jdoering
Starting Member
32 Posts |
 Posted - 2002-08-02 : 14:25:54
|
| Has anyone ever passed variable to a DTS package from a command line? I cannot find this anywhere. Is this possible?Thanks,JulieThank you both, that should do it.Edited by - jdoering on 08/02/2002 14:35:03 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-02 : 14:28:18
|
| It's in Books Online under "dtsrun", you can do it using the /A switch. |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-02 : 14:32:04
|
| If you can't find it anywhere, then you are probably running SQL7.0. The /A flag is new to DTS in SQL 2000...Jay White{0} |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-02 : 15:09:05
|
| If it turns out you are on SQL2000 then you can use dtsrunui to easily generate command lines for dts and add your input global variables. Goto Start>Run and type in dtsrunui and hit enter. This brings up the user interface, select your server and package and click on advanced. Select your input variables and enter the values and then click on generate. You can then copy and paste the command line. It gives you a good idea of what it should look like e.g.DTSRun /S "(local)" /N "New Package" /A "input1":"8"="hi" /EHTHJasper Smith |
|
|
|
|
|
|
Passing a variable to a DTS Package