Upgrade SSIS Packages from 2012 to 2014 deletes Package Format and Annotations

  • 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

  • I opened an SQL Connect Bug

    https://connect.microsoft.com/SQLServer/feedback/details/1438953

  • 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