Post reply

How do I clean old data connections out of an SSIS package?

  • March 27, 2014 at 10:55 pm

    #1700973

    Well, this is what I got when I tried that:

    Error 1 Error loading 'Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx' : The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)). G:\Mhub_Operations\DATA\SSIS\Archive_Snapshots\Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx 1 1

    Forgot one thing that must be done before deleting the <DTS:ConnectionManager>. Each has a <DTS:Property DTS:Name="DTSID"> tag which has a GUID value. These appear where the connection is referenced in the package file and need to be removed.

    In a control flow -> Connection="{478ca604-9df0-4bd2-983e-19ed1c6b77ed}"

    in a data flow -> connectionManagerID="{55438835-4d17-4afe-8525-a1d58a94f164}"

    Another way would be deleting only those connecctions which DTSID cannot be found elsewhere in the file.

  • March 28, 2014 at 9:44 am

    #1701196

    Eirikur Eiriksson (3/27/2014)

    Well, this is what I got when I tried that:

    Error 1 Error loading 'Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx' : The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)). G:\Mhub_Operations\DATA\SSIS\Archive_Snapshots\Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx 1 1

    Forgot one thing that must be done before deleting the <DTS:ConnectionManager>. Each has a <DTS:Property DTS:Name="DTSID"> tag which has a GUID value. These appear where the connection is referenced in the package file and need to be removed.

    In a control flow -> Connection="{478ca604-9df0-4bd2-983e-19ed1c6b77ed}"

    in a data flow -> connectionManagerID="{55438835-4d17-4afe-8525-a1d58a94f164}"

    Another way would be deleting only those connecctions which DTSID cannot be found elsewhere in the file.

    Excellente! This is working. Thanks.

  • May 29, 2015 at 8:44 am

    #1801606

    Someone more specifically trained and experienced than me is welcome to correct me, however I have found the following solution is quite simple and has never broken me:

    1. Copy the GUID {WITH curly braces}

    2. Alt+V, C - opens the XML text

    3. Ctrl+H

    3a. Scope your "Look In" to "ENTIRE SOLUTION"

    3b. Paste your GUID to the "Find" box

    3c. Make sure your "Replace" box is empty

    4. Replace ALL

    This will force SSIS to re-identify all connection managers using that stale old GUID with a fresh new GUID!

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply