?
Solved

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

Posted on 2014-11-14
3
Medium Priority
?
168 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 66

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 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 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 43

Accepted Solution

by:
Eugene Z earned 1000 total points
ID: 40445803
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
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
Viewers will learn how the fundamental information of how to create a table.

719 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