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