title: How to resolve the error loading SSIS packages using 32-bit dtexec on a x64 machine?
body: <p>I have Integration Services packages that need to work with Excel files (shudder) and also need to execute on x64. I have a handle on the whole SSIS x64 vs. 32-bit issue, so I am scheduling these problem-child packages using MS suggested technique of using SQL Agent job step type <code>Operating System</code> / <code>CMDExec</code>, with a command line string that explicitly calls the 32-bit dtexec. So far so good.</p>
  
  <p>Here's the issue: the packages still fail to load, and complain about failing to load not the Excel bits, but instead my handy Log Provider that logs to SQL Server. This is the error message, edited for object names:</p>
  
  <blockquote>
    <p>Started:  2:33:01 PM<br>
    Error: 2009-07-24 14:33:06.51<br>
    Code: 0xC0010018<br>
    Source:<br>
    Description: </p>
    
    <p>Error loading value "&lt;DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"&gt;&lt;DTS:Property DTS:Name="DelayValidation"&gt;0&lt;/DTS:Property&gt;&lt;DTS:Property DTS:Name="ObjectName"&gt;My_LogCon&lt;/DTS:Property&gt;&lt;DTS:Property DTS:Name="DTSID"&gt;{86320FE6-AEFD-4A58-9277-84685B9B9" from node "DTS:ConnectionManager".<br>
    End Error  Could not load package "c:\folder\mypkg.dtsx" because of error 0xC0010014.<br>
    Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.  ...  Process Exit Code 5.  The step failed.</p>
  </blockquote>
  
  <p>The packages run perfectly in 32-bit Visual Studio/debug. Anyone seen this type of thing?</p>