none
Deploying standard changes to SSIS packages RRS feed

  • Question

  • A couple glitches were discovered in our SSIS template.  Approximately 100 packages were built from the template.  Is there a mechanism to update all packages with the changes?  Or do I have to open each one and manually change?
    Tuesday, April 1, 2014 6:27 PM

Answers

  • If you verified that by changing a portion of the package file (which is plain text - XML) you fix it and that the rest of the 100 packages has it then you can apply a global text search and replace.

    I think I did something like that in the past with TextCrawler: http://www.digitalvolcano.co.uk/tcdownloads.html


    Arthur My Blog



    Tuesday, April 1, 2014 6:35 PM
    Moderator
  • The .dtsx itself is actually a XML behind the scene. You can right click on the dtsx file in BIDS and choose view code to see code behind which is the XML.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 2, 2014 1:35 PM
  • I'm into the xml and notice a lot of difference between packages for DTS:DTSID   I searched the net trying to find what DTS:DTSID is and if I should be replacing this text.

    Hi Hawk73ku,

    Each package object has a GUID, and the GUID is marked as the DTSID element in the XML code of the .dtsx file. Generally, it doesn’t matter to change the GUID of a package object only if the GUID is unique. However, when we try to modify certain XML code snippet of a package, there is no need to modify the DTSID element actually.

    You can first make the changes to a package, and compare and find out the modified code snippet. Then, you can open the code of any one package, and then perform text replace in the project or entire solution scope.

    Regards,


    Mike Yin
    TechNet Community Support

    Tuesday, April 8, 2014 9:16 AM
    Moderator

All replies

  • If you verified that by changing a portion of the package file (which is plain text - XML) you fix it and that the rest of the 100 packages has it then you can apply a global text search and replace.

    I think I did something like that in the past with TextCrawler: http://www.digitalvolcano.co.uk/tcdownloads.html


    Arthur My Blog



    Tuesday, April 1, 2014 6:35 PM
    Moderator
  • Changes were tested and verified.  Where is the xml stored?  I would like to try this on a small set of packages that don't have a lot of columns mapped before going for the full Monte.
    Wednesday, April 2, 2014 1:25 PM
  • The .dtsx itself is actually a XML behind the scene. You can right click on the dtsx file in BIDS and choose view code to see code behind which is the XML.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 2, 2014 1:35 PM
  • I'm into the xml and notice a lot of difference between packages for DTS:DTSID   I searched the net trying to find what DTS:DTSID is and if I should be replacing this text.
    Thursday, April 3, 2014 8:35 PM
  • If you can preserve DTSID great, if not perhaps (back all up) you can reset them using BIDS Helper.

    Arthur My Blog

    Thursday, April 3, 2014 8:51 PM
    Moderator
  • I'm into the xml and notice a lot of difference between packages for DTS:DTSID   I searched the net trying to find what DTS:DTSID is and if I should be replacing this text.

    Hi Hawk73ku,

    Each package object has a GUID, and the GUID is marked as the DTSID element in the XML code of the .dtsx file. Generally, it doesn’t matter to change the GUID of a package object only if the GUID is unique. However, when we try to modify certain XML code snippet of a package, there is no need to modify the DTSID element actually.

    You can first make the changes to a package, and compare and find out the modified code snippet. Then, you can open the code of any one package, and then perform text replace in the project or entire solution scope.

    Regards,


    Mike Yin
    TechNet Community Support

    Tuesday, April 8, 2014 9:16 AM
    Moderator