I have developed several SSIS packages. Delivered to first customer who was on 32 bit. No problem calling all packages through Agent jobs using SSIS package store. Delivered to 2nd customer who was running on 64 bit OS. Some packages got error message. Could not load package 'r:...' because of error 0xC0010014. I corrected error by changing the type of the package to CmdExec and running the command line like so: "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTexec.exe" -f "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MPSC Batch Jobs\OPIntInterStateDualParticipation.dtsx" -conf "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MPSC Batch Jobs\OPIntInterStateDualParticipation.dtsConfig". I delivered to the 3rd customer who was also running on a 64 bit os. These guys are on a cluster too. Neither previous customer is on a cluster. I am still getting the "Could not load package" error. this occurs when CPackage::LoadFromXML fails. I am out of things to try. Anybody got a suggestion?
asked Jun 17, 2010 at 09:51 AM in Default