You can create configuration file(s) for the SSIS package that have the connection information for different servers. Too big a subject to go into here, but see "Package Configuration" in BOL http://msdn.microsoft.com/en-us/library/ms141682(SQL.90).aspx.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply