My SSIS package is running fine in Visual Studio locally. The package contains (at the end) a process task to execute an .exe file that generates a xml file.
Note: Earlier, The package was scheduled in SQL Server 2005 and it was running fine. Now, I have migrated this package to SQL server 2012 and creating agent job in 2012.
On Monday 4 PM: I deployed the package to SSIS catalog and scheduled it to run every week day at 7 PM.
Monday 7 PM: Job ran successfully.
Tuesday 7 PM: Job Failed with error
Executed as user: ProxyID. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5548.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:05:02 AM Error: 2015-05-11 11:12:25.65 Code: 0xC0029151 Source: Execute XML Generator Execute Process Task Description: In Executing "\Servername\path\app.exe" "" at "", The process exit code was "-532459699" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:05:02 AM Finished: 11:12:25 AM Elapsed: 442.922 seconds. The package execution failed. The step failed.
Wednesday 4 PM:
Opened the agent job
In job step, deselected SSIS catalog option (everything got reset)
Again selected SSIS catalog and provided the same server name
Selected the required package from catalog
Pressed OK
Wednesday 7 PM: Job ran successfully
Thursday 7 PM: Job failed with same above error.
Friday 4 PM: I did the same thing what was done in Wednesday 4 PM.
Friday 7 PM: Job ran successfully.
Why the package and SQL agent job scheduled is behaving like this? Please provide your suggestions and help. I must fix this issue before the next run. Your kind help will be much appreciated.
