Hi Experts, Im facing one issue. Agent triggers SSIS package, Package fails same is captured. But agent run is considered as success how to make agent also fail. Please help me to solve this issue. Thanks, abdul2010

in SSMS, right click on that job, select properties, in steps tab,select the step which runs ssis package, and set "on failure action" as "quit the job reporting failure"http://www.rad.pasfu.com