?
Solved

Copying SSIS packages from SQL Server 2008 to 2014

Posted on 2014-12-04
3
Medium Priority
?
55 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
[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 27

Accepted Solution

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

Assisted Solution

by:DcpKing
DcpKing earned 1000 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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

765 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