SQL Agent 2012 fails with error code : 0x00000001 however SQL Agent 2008 successfully executes for the same package

0
votes

I have tried to execute a package containing script component which uses Excel Component in SQL Agent 2012 but has failed with

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)

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" .

However doing the same in SQL Agent 2012 server is not working out .

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.

At both servers , package has been successfully migrated and executed

ssissql-server-2012
There must be more error messages than '0x00000001'. Please post them. – Nick.McDermaid
Hi Please find the description : 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). – user3441754
Is this you: social.msdn.microsoft.com/Forums/sqlserver/en-US/… ? – Nick.McDermaid
Here's another: social.msdn.microsoft.com/Forums/en-US/…. If you want ti investigate the problem further you could use processmon to identify if the process is failing to create a required file. – Nick.McDermaid
Thanks for the help however, my packages are on Windows Server 2012 and we are seeing this issue – user3441754