sql server 2008 - Execute Process Task Error -

message

executed user: proxyid. microsoft (r) sql server execute package utility version 11.0.5548.0 64-bit copyright (c) microsoft corporation. rights reserved. started: 11:05:02 error: 2015-05-11 11:12:25.65 code: 0xc0029151 source: execute xml generator execute process task description: in executing "\servername\path\app.exe" "" @ "", process exit code "-532459699" while expected "0". end error dtexec: package execution returned dtser_failure (1). started: 11:05:02 finished: 11:12:25 elapsed: 442.922 seconds. package execution failed. step failed.

i migrating ssis package (sql server 2005 version) sql server 2012. have done required connection changes , deployed target. created job , executing through valid proxyid.

in package, there multiple dataflow tasks, batch file (gets executed process task) , @ final app.exe file (gets executed process task).

the above error coming last .exe file (proxyid has proper access file location).

why in executing "\\servername\path\app.exe" "" @ "" ?

what mean process exit code "-532459699" while expected "0" ?

edit:

note: package running ssdt local machine , sql server package store (ssis instance). running cmd.exe locally.

getting failed agent job.

edit 2

while deploying ssis package ssis catalog of 2012 version. scheduled job running same day schedule created, same failing on next day same error.

requesting help.

please check whether package runs in 32-bit runtime mode or 64-bit runtime mode in bids checking run64bitruntime property of project. then, make sure package runs in same runtime mode in sql server agent job checking or unchecking “use 32 bit runtime” option execution options of job step.

if not issue, please create job uses cmdexec type job step call executable “\servername\path\app.exe”. if job fails, issue occurs because of issue between executable , sql server agent rather ssis package itself.