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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-09-08 : 14:26:00
|
| is there any way in DTS I can specify the connection in a global variable.So that when I move the DTS package from one environemnt to another I can just specify it through the global variable |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 14:30:19
|
| http://www.nigelrivett.net/SetDTSRunTimeValues.htmlTara |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-08 : 17:26:26
|
| Tara,If I want to do a datapump and from source to destination in a SQL Server.Will this be helpful.I need to do both the source and destination connection to be dynamic. |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-08 : 17:31:15
|
| tara,will "Dynamic Properties Task" to assign all the connections will help |
|
|
|
|
|
|
issue with global variable