SQL Agent 2012 fails with error code : 0x00000001

2019-06-14 05:56发布

问题:

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