• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

Converting SSIS package from 2005 to 2012

Any conversion tool I can use? Seems conversion is not as simple as opening the old code and the system recognizing a conversion needs to be done then does it.

I read somewhere that I should see a conversion screen... Nope.. Never get that..

I got the warnings below, then an empty container when I brought a 2005 SSIS package into VS2012.

SSISConversion.jpg
0
moosetracker
Asked:
moosetracker
1 Solution
 
lcohanDatabase AnalystCommented:
Did you tried this?

"SSIS Package Upgrade Wizard is installed when Integration Services is installed"
http://technet.microsoft.com/en-us/library/cc280547.aspx

"Upgrade Integration Services Packages"
http://technet.microsoft.com/en-us/library/cc280546.aspx



Just make SURE you have a backup very safe of ALL old SQL Server 2005 DTSX package files before attempting any of the two.
0
 
moosetrackerAuthor Commented:
Thanks, and yes the old DTSX packages are on a totally different machine so very safe.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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