Solved

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

Posted on 2014-11-14
3
122 Views
Last Modified: 2016-02-11
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
Comment
Question by:rhservan
3 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40442751
>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
 
LVL 48

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 40442826
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
 
LVL 42

Accepted Solution

by:
EugeneZ earned 250 total points
ID: 40445803
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
backup job space check 4 43
backup and restore 21 28
Select single row of data for each ID in Select Statement 7 26
SQL View / Qtry 3 10
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question