Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

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.
0
rhservan
Asked:
rhservan
2 Solutions
 
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ãoMSSQL 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
 
Eugene ZCommented:
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now