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 the deployment server be my centralized package repository and using the same configuration to complete the processing for all the other servers that need to be backed up.

Does anyone have any insight into what would be a cost/benefit to this type of configuration?

Thanks