CODEWITHSUNDEEP
ssissql-server-data-toolsssis-2012
VHK
VHK

Reputation: 193

The package failed to load due to error 0xC0011008 "Error loading from XML.

I have migrated the DTS (2005) to SSIS DTSX(2012) and migrated package runs through the SSDT but doesn't run through the Web Application which triggers the SSIS package.

Below is complete error message

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.

I have provided full permission and SET "Run64bitRunTime" to FALSE, still no luck.

Unfortunately this is not working at Client Server (SQL 2012 SP3 installed) but is working in my development server (SQL 2012 SP3).

Any suggestions are appreciated. Thanks in advance.

Regards,

VK

Upvotes: 0

Views: 14699

Answers (2)

PatMatt
PatMatt

Reputation: 31

Another thing to check is the project property Deployment Target Version. Make sure this is the correct SQL version. By default it goes to SQL Server VNext. This was the issue for me.

Upvotes: 3

Looking_for_answers
Looking_for_answers

Reputation: 343

Try this:

by changing packet runtime from 64 to 32 bit. it should do the trick

Upvotes: 2

Related Questions