Does SQL Server Agent capture errors resulting from an SSIS package run?

0
votes

I have a SQL Server Agent job set up to execute a SSIS package once a day. The history log for that Job has been reporting success every day, but I don't know if it's simply telling me that it was successful in launching the package, or if the package tasks actually completed without error.

Would the Job history log tell me if something went wrong while the package was running its tasks, or is there another error report I'd need to look for to see the details of the package run.

1
sql-serverssis
Yes you'd see a red x (unless you specifically configured your job to not return errors). You should check the logs anyway – Nick.McDermaid
Ok thanks for the information, Nick. – Stpete111
do you log on sysssislog?? – Nambu14
No I don't Does this matter? – Stpete111

1 Answers

-1
votes

Per Nick.McDermaid:

"Yes you'd see a red x (unless you specifically configured your job to not return errors). You should check the logs anyway."