SSIS 2008 Package error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

SSIS 2008 Package error

Author

Topic

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-05-14 : 04:01:34

When i have created a package using SSIS 2005 and loaded it through .net its working fine...

BUT

When i create same package using 2008, it ends with following error

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.

{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 (0xC0011008): 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.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
at Utilities_DBDataIntegration.DataExtraction(String mauza) in e:\MY_APPLICATION\UI\Utilities\DBDataIntegration.aspx.cs:line 152}

Whats wrong with it ???

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-05-17 : 03:43:07

ohhhhhhhhhhhhhhhhhhhhhhhhhhh

I was using sql server 2005 assembly reference in web.config and executing SSIS 2008 package. And that was my mistake.

I had replaced these references and now its working fine.

jacarmonaro
Starting Member

1 Post

Posted - 2010-06-04 : 12:53:52

Hi i have the same problem but i don't know wich assembly change. Can you give the code that you changed? Thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources