I am making an installer to deploy our SSIS packages for our customers so they could run an install sheild type project. I need to change datasources in the package depending on our customer. So, I made a .NET app that uses XML.XPath to
parse the dtsx package and update the datasources with their server and databases. The problem is when I do XML.XMLDocument.Save() it reformats the XML, to me is seems only a whitespace formatting. This is fine for SQL 2008 packages but SQL 2005
dtutil.exe chokes with the following error on deployment:
Could not load package "ProcessCubes.dtsx" because of error 0xC0011008.
Description: The package failed to load due to error 0xC0011008 "Error loading f
rom XML. No further detailed error information can be specified for this problem
because no Events object was passed where detailed error information can be sto
red.". This occurs when CPackage::LoadFromXML fails.
View Complete Post