Home Forums SQL Server 2005 Business Intelligence How do I clean old data connections out of an SSIS package? RE: How do I clean old data connections out of an SSIS package?

  • March 28, 2014 at 9:44 am

    #1701196

    Eirikur Eiriksson (3/27/2014)

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

    Error1Error 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.dtsx11

    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.