Solved

Copying SSIS packages from SQL Server 2008 to 2014

Posted on 2014-12-04
3
27 Views
Last Modified: 2016-06-16
Hello
I need to copy ssis packages from one server to another, so far I was using dtutil but without any success
I do have 2012 sql server with packages in msdb and I need to move them to 2014 sql server to msdb
 I ran dtutil on 2012 server and specified  server name for 2014 ,dtutil showed it did work but there are no packages in msdb 2014 server
0
Comment
Question by:robertfl77
3 Comments
 
LVL 26

Accepted Solution

by:
Zberteoc earned 250 total points
ID: 40483404
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 250 total points
ID: 40486600
As Rui's article says, physically move copies of the development files to the new server and then open each with the 2014 version of SSDT and convert them to 2014-type from 2008-type.  While you're doing it, take to opportunity to document each one, including noting down places where they can be improved, etc. If you're like most normal developers you'll never get the time for a full review except at times like this!

One of the things you will need to do is decide on the new deployment model, but once you've done that life becomes much easier!

hth

Mike
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
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.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now