title: SQL Agent 2012 fails with error code : 0x00000001 however SQL Agent 2008 successfully executes for the same package
body: <p>I have tried to execute a package containing script component which uses Excel Component in SQL Agent 2012 but has failed with</p>
  
  <pre><code>Code: 0x00000001 Source: Backlog Supplies Validation Description: 
  Exception has been thrown by the target of an invocation. 
  End Error DTExec: The package execution returned DTSER_FAILURE (1)
  </code></pre>
  
  <p>However when I call the same package via SQL Agent 2008 R2 initially it failed with  error code : 0x00000001 . Later it succeeded after creating a folder with name  "Desktop" in the following path "C:\Windows\SysWOW64\config\systemprofile" .</p>
  
  <p>However doing the same in SQL Agent 2012 server is not working out .</p>
  
  <p>Please note SQL Agent 2012 is in a different server having Windows server 2012 
  SQL Agent 2008 R2 is in a server that has Windows server 2008 installed.</p>
  
  <p>At both servers , package has been successfully migrated and executed</p>