June 15, 2015 at 3:59 am
Hi there,
can anyone verify that when I upgrade my SSIS-Packages with VS2013 to SQL Server 2014 the format and annotations will be deleted.
Format shows only changes if you differ from the "auto"-Formatation
If you have simple package with one annotation and then Upgrade. The Upgrade Version shows no annotation. However in the XML-Code in the CData-Section where format and annotations are saved, you will find it.
If you change anything in the package after that and save the annotation will be deleted completly.
Is there a known bug oder perhaps a fix to that?
Cheers,
Christian
June 16, 2015 at 3:49 am
I opened an SQL Connect Bug
https://connect.microsoft.com/SQLServer/feedback/details/1438953
June 23, 2015 at 3:01 am
This is how you can fix it, before MS delivers the right solution:
After the package is migrated you find in the XML-Code following part
<DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>
<!--This CDATA section contains the layout information of the package. The section includes information such as (x,y) coordinates, width, and height.-->
<!--If you manually edit this section and make a mistake, you can delete it. -->
<!--The package will still be able to load normally but the previous layout information will be lost and the designer will automatically re-arrange the elements on the design surface.-->
<Objects
Version="sql11">
You will have to change manually to following:
<Objects
Version="sql12">
when you open the package after the change then the apperance and annotations will be shown again.
I do not know if this is a Migration Wizard bug, that does not elevate the Version to sql12 or if it is a SSIS-Plugin-Bug, that does not handle the entry sql11 right. This depence on how Microsoft wanted to design it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply