Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

Copying SSIS packages from SQL Server 2008 to 2014

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
robertfl77
Asked:
robertfl77
2 Solutions
 
ZberteocCommented:
0
 
DcpKingCommented:
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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now