title: Why does a package that runs well on dtexec fails to run under SQL Server Agent job?
body: <p>I have got a package on local C: drive, if I run it as a part of a SQL Agent Job, it fails:</p>
  
  <pre><code>02/20/2013 17:38:45,MyUpload,Error,3,FMF-S3-1507\EOS01,PAM_MyUpload,Run MyUpload SSIS Package,,
  Executed as user: MARKETS\SVCSQLDEV. 
  Microsoft (R) SQL Server Execute Package Utility  Version 10.0.5500.0 for 64-bit  
  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    
  Started:  17:38:45  Error: 2013-02-20 17:38:45.72     
  Code: 0xC0011007     
  Source: {14BE11F5-B737-4A6E-96E6-111635631749}      
  Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.  End Error  
  Error: 2013-02-20 17:38:45.72     
  Code: 0xC0011002     
  Source: {14BE11F5-B737-4A6E-96E6-111635631749}      
  Description: Failed to open package file "C:\MyFolder\Package.dtsx" due to error 0x80070003 "The system cannot find the path specified.".  This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.  End Error  
  Could not load package "C:\MyFolder\Package.dtsx" because of error 0xC0011002.  
  Description: Failed to open package file "C:\MyFolder\Package.dtsx" due to error 0x80070003 "The system cannot find the path specified.".  This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.  
  Source: {14BE11F5-B737-4A6E-96E6-111635631749}  
  Started:  17:38:45  
  Finished: 17:38:45  
  Elapsed:  0.047 seconds.  
  The package could not be found.  The step failed.
  ,00:00:00,0,0,,,,0
  </code></pre>
  
  <p>However, if I copy the command line from SQL Agent job step and run it with <code>DTExec.exe</code>, it succeeds:</p>
  
  <pre><code>C:\Program Files\Microsoft SQL Server\100\DTS\Binn&gt;DTExec.exe /FILE "C:\MyFolder\Package.dtsx"  /CHECKPOINTING OFF /REPORTING E
  Microsoft (R) SQL Server Execute Package Utility
  Version 10.50.1600.1 for 32-bit
  Copyright (C) Microsoft Corporation 2010. All rights reserved.
  
  Started:  17:44:00
  DTExec: The package execution returned DTSER_SUCCESS (0).
  Started:  17:44:00
  Finished: 17:44:56
  Elapsed:  55.266 seconds
  </code></pre>
  
  <p>What can I try to fix it in the job step? Is a jobstep of type commandshell the right way forward?</p>