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 |
|
gquint
Starting Member
2 Posts |
 Posted - 2006-06-01 : 04:23:43
|
| I am setting up a data warehouse in which data-extracts from severall instances of a software system gets collected. So I have built a package that works fine for the database on site A and now I want to reuse this package for the databases in site B, C, D etc. The data structure is exactly the same, I just have to change the database connection. I was thinking of using an ini-file to read the database-location from but I don't see the possibility to create different jobs that call the same package but with a different ini-file as a parameter. Any idea's? |
|
|
gquint
Starting Member
2 Posts |
Posted - 2006-06-01 : 05:36:59
|
| I already found a solution for this problem: global variables! I did not knew I could pass them on through the commandline. Still, if you have a whole bunch of parameters an ini-file would be nicer to use.Gerard. |
 |
|
|
|
|
|
Reuse DTS-packages