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 |
|
DMcG
Starting Member
2 Posts |
 Posted - 2004-09-09 : 19:20:39
|
| I have a DTS package which loads data from around 40 or 50 flat files into corresponding tables in a test database. I'll be using the package to load data into the same set of tables in around 4 or 5 different databases on the same server. What's the easiest way to change the target database that contains the tables ?Do I have to use a global variable for this - and if so, is there a simple guide on how to do this as most of the examples I've seen seem fairly convoluted and involve ActiveX. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-09 : 19:21:33
|
| http://www.nigelrivett.net/SetDTSRunTimeValues.htmlTara |
 |
|
|
DMcG
Starting Member
2 Posts |
Posted - 2004-09-09 : 23:31:18
|
That web site is unavailable, but I did find this link after a bit of rummaging around[url]http://databasejournal.com/features/mssql/article.php/3073161[/url] which got me up and running  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-10 : 12:18:05
|
| The link works fine for me.Tara |
|
|
|
|
|
|
Changing DTS Target database