Solved

Copying SSIS packages from SQL Server 2008 to 2014

Posted on 2014-12-04
3
34 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

773 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