Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2014-03-31 : 15:27:48
|
| Hello -My SQL Server Agent shows successful completion of SSIS job but messages in Log File view shows that there was an error. How can I get the Agent to fail if there was an error or a failed to execute in the SSIS package?Thank you,David |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-04-13 : 15:03:13
|
| Go to job step properties for the step executing the package by expanding the jobs-> properties -> edit step in SQL management studio object explorer. Go to advanced tab and for the On failure action set value as Quit the Job reporting failure------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSIS Package Not Failing?