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 |
|
theboyholty
Posting Yak Master
226 Posts |
 Posted - 2013-02-19 : 09:43:33
|
| I have just created a job in SQL Server agent.It consists of 17 SSIS packages running one after the other. The Job has completed but says it failed, and yet each of the individual steps completed and executed sucessfully.What am I missing?---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2013-02-19 : 11:17:30
|
| Was your last step to quit the job reporting failure instead of success?JimEveryday I learn something that somebody else already knew |
 |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2013-02-19 : 11:26:56
|
| Yes it was!*punches self in face*Cheers Jim---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2013-02-19 : 11:29:43
|
| Finally, the easy answer was the right one!JimEveryday I learn something that somebody else already knew |
|
|
|
|
|
|
Job failed but each component suceeded