How do I migrate SSIS packages to a new server with a different name?

I need to migrate about 20 SSIS packages to a new server environment.  The new server has a different name.

I am mostly concerned with the variables on each package and especially regarding server environments and pathing.
 
Let me know if I can provide any additional information to assist.
rhservanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I am mostly concerned with the variables on each package
You should be able to migrate the .dtsx without any changes, but in the scheduler (SQL Agent, ActiveBatch, whatever) that executes these package, as long as all connections to this server are parameter-driven, then pass the connection string to that parameter when scheduling the job.

You'll need to provide us more details on 'variables on each package' for a more precise answer.
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
I am mostly concerned with the variables on each package and especially regarding server environments and pathing.
That's why you should network shares. Now you need to create the same path in the new server or once you're going to edit the packages, this time use network shares.
0
All Courses

From novice to tech pro — start learning today.