Home Forums SQL Server 2005 SQL Server 2005 Integration Services I want to run someone else's SSIS package, which file do they need to send me? RE: I want to run someone else's SSIS package, which file do they need to send me?

  • March 17, 2014 at 1:16 am

    #1697562

    Shawn, In the XML file I find three connectionManagers.

    It seems that VS is not liking the OData one. So, I removed it (left other two alone) and tried reload, but because of other dependencies am getting further errors.

    If I remove the downstream data tasks that depend on this connectionManager then I am in effect deleting the package I need to reverse engineer..I think.

    Can you see around this?

    ----error before I remove Odata connectionManager (leaving other two alone)

    TITLE: Microsoft Visual Studio

    ------------------------------

    Error at Asset_MultiCast []: The connection type "ODATA" specified for connection manager "OData Source" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

    Error at Asset_MultiCast []: Error loading value "<DTS:ConnectionManagers xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:ConnectionManager DTS:refId="Package.ConnectionManagers[DispositionDataValidation]" DTS:CreationName="ODBC" DTS:DTSID="{E8EE4378-E62D-491F-B908-93FAB9E40D01}" DTS:ObjectName="Disposit" from node "DTS:ConnectionManagers".

    ------------------------------

    ADDITIONAL INFORMATION:

    The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.

    (Asset_MultiCast)

    ------------------------------

    The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.

    (Asset_MultiCast)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    ---------error after removing OData connectionManager

    TITLE: Microsoft Visual Studio

    ------------------------------

    Error at {4EC5F2F0-0A5D-488B-A67D-E81F733D2D45} []: The object "/DTS:Executable/DTS:Executables/DTS:Executable/DTS:ObjectData/pipeline/components/component/connections/connection" references ID "Package.ConnectionManagers[OData Source]", but no object in the package has this ID. If the object "/DTS:Executable/DTS:Executables/DTS:Executable/DTS:ObjectData/pipeline/components/component/connections/connection" was added to the package by a manual edit ensure that the referenced object with ID "Package.ConnectionManagers[OData Source]" is also added to the package.

    Error at {4EC5F2F0-0A5D-488B-A67D-E81F733D2D45} []: The object "/DTS:Executable/DTS:Executables/DTS:Executable/DTS:ObjectData/pipeline/components/component/connections/connection" references ID "Package.ConnectionManagers[OData Source]", but no object in the package has this ID. If the object "/DTS:Executable/DTS:Executables/DTS:Executable/DTS:ObjectData/pipeline/components/component/connections/connection" was added to the package by a manual edit ensure that the referenced object with ID "Package.ConnectionManagers[OData Source]" is also added to the package.

    ------------------------------

    ADDITIONAL INFORMATION:

    The package failed to load due to error 0xC001001C "The object "%1" references ID "%2", but no object in the package has this ID. If the object "%1" was added to the package by a manual edit ensure that the referenced object with ID "%2" is also added to the package.". This occurs when CPackage::LoadFromXML fails.

    ({4EC5F2F0-0A5D-488B-A67D-E81F733D2D45})

    ------------------------------

    The package failed to load due to error 0xC001001C "The object "%1" references ID "%2", but no object in the package has this ID. If the object "%1" was added to the package by a manual edit ensure that the referenced object with ID "%2" is also added to the package.". This occurs when CPackage::LoadFromXML fails.

    ({4EC5F2F0-0A5D-488B-A67D-E81F733D2D45})

    ------------------------------

    BUTTONS:

    OK

    ------------------------------