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 |
|
seanworking
Starting Member
13 Posts |
 Posted - 2009-11-28 : 16:05:09
|
| I'm at the beginning stage of learning SSIS and have created a package that runs stored procedures that backup/copy and restore a database from one server to another. I have the package deployed on one server that then connects to the other servers via a linked server connection.I'm considering having one deployment server be my centralized package repository and using the same configuration to complete the processing for all the other servers that would be accessed by the packages.Does anyone have any insight into what would be a cost/benefit to this type of configuration?ThanksEdit/Delete Message |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
seanworking
Starting Member
13 Posts |
Posted - 2009-11-28 : 19:01:05
|
Thanks Tara. I will take that as a thumbs up for centralized server deployment  |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-12-01 : 06:08:53
|
| We've a dedicated SSIS server which is used for running various ssis packages, and it's proved a very worth while investment of money and time - Makes life a lot simpler.Well recommend |
|
|
|
|
|
|
SSIS package deployment strategy