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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-03-09 : 07:56:11
|
| I have many many DTS packages - each with a target and source connection. But I dont want to keep specifying the connection parameters for each package. When I change from the Dev to the Live environment, these two connection strings will be different.So I really need a global way of setting the source and destination connection properties. How can I do that? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-09 : 14:08:15
|
| look into using dynamic properties and global variables. you might want to google on those terms and check some of the articles you find.btw, www.sqldts.com is a really good DTS resource to use and they have many examples.-ec |
 |
|
|
|
|
|
Connection Settings