I'm calling Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage
from a .net(V4.0)
application to load SSIS package that are installed into the local disk of a VM Windows Server 2016. I run this code from Visual Studio 2017
Community in debug mode to test my integrations.
The packages SSIS were created in Visual Studio 2010 and I migrated them to be compatible with Visual Studio 2017. They integrate data into a SQL server 2017. If I simply execute my packages from my SSIS
solution it works perfectly, but when I load them within my other C# code using Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage
, I get the 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.
By the way, is not a code problem as it works perfectly in my actual environment(Windows Server 2012 R2
targeting SQL Server 2017
) with the exactly same code. I think is more version compatibility related or server configuration.
I resolved the problem upgrading my project to version 4.6 of the .net framework. Also as Matt said, you have to install the SDK tools also. Thanks for the help.