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 |
|
NewHampshire
Starting Member
14 Posts |
 Posted - 2009-01-22 : 09:51:22
|
| Hello there. Here is my situation. I have a fairly complex SSIS package that runs every night to bring new reporting data onto a production server. I wanted to replicate this on a dev server. I managed to copy everything over, change the connections, update the scripts to refer to the right server, and get it running.But it seemed to me to be an absurdly inefficient way of going about it. Is there any way to design a package so that a single working copy could be maintained (either on my machine or maybe in Visual Source Safe) and deployed on various servers inhereting things like connections from the server they are installed on?Thanks |
|
|
|
|
|
Deploying one package to multiple servers