My package runs fine on the dev server with remote database. SSMS deploys it to the msdb on the remote server, no problem, and it runs there with no problem.
But when I try to use dtutil from the command line to deploy it from a local .dtsx file to the remote server, I get the following message:
Microsoft (R) SQL Server SSIS Package Utilities
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2004. All rights reserved.
Could not load package "foo.dtsx" because of error 0xC0011008.
Description: 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.
Dev system is using Visual Studio 2008 and BI Studio R2, database server is SQl 2008 but not R2.
I don't think that matters.
What might matter is that I have embedded spaces in the file names and package names - just renaming the file didn't seem to help, I think I'll try renaming the package, for lack of any better idea to try.
Or, could it be a 32bit/64bit thing? I'm not sure who is 32bit and who is 64bits, actually.
View Complete Post