July 15, 2014 at 9:37 am
Hello,
I am in the process of upgrading my SSIS packages from 2005 - 2012. I ran the upgrade wizard and pointed to a copy of my current SSIS packages (I have over 200), and just about all of them have the same message. I know that most of these messages are informational, but the one that concerns me is the following....
The package format was migrated from version 2 to version 6. It must be saved to retain migration changes.
Does this mean that I have to open the package in SSDT or VS, save it and then re-deploy? I hope not because then it's going to be a long day for me! :crazy:
Also, how can I tell if a SSIS package has been upgraded to the latest version?
Any help is appreciated and thanks very much for all your help in the past.
SQL-TG
The are no problems, only solutions. --John Lennon
July 15, 2014 at 10:58 am
I've never run the Upgrade Wizard, but my guess would be that this is just a message carried over from SSDT if you open a package/project in SSDT. I would bet you are all set.
You can verify the upgrade by looking at the XML code for the package and look for the Property, PackageFormatVersion, which is 6 for 2012. I don't know what it is for 2005 because I don't have access to any 2005 packages right now.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 15, 2014 at 11:48 am
Thanks Jack!
The are no problems, only solutions. --John Lennon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply