none
System.Runtime.InteropServices.COMException error while using DQS connection manager RRS feed

  • Question

  • Hi,

     We are using SQL Server 2017 enterprise edition. We are getting below error while using DQS connection manager in SSIS. Please help in this regard ASAP.


    Severity Code Description Project File Line Suppression State
    Error Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.
     ---> System.Runtime.InteropServices.COMException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

       at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackagePersist100.LoadPackageFromXML(Object vSource, Boolean vbSourceIsLocation, IDTSEvents100 pEvents)
       at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events)
       --- End of inner exception stack trace ---
       at Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events)
       at Microsoft.SqlServer.Dts.Runtime.Project.LoadPackage(IProjectStorage storage, Package package, String streamName, IDTSEvents events)
       at Microsoft.SqlServer.Dts.Runtime.PackageItem.Load(IDTSEvents events)
       at Microsoft.SqlServer.Dts.Runtime.PackageItem.get_Package()
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.IncrementalBuildThroughObj(IOutputWindow outputWindow)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow) 0

    Thanks,

    Rakesh

    Saturday, June 22, 2019 7:14 AM