Log error details in SSIS when executed by an SQL Agent job

If an SSIS package is executed by a SQL Agent job, is there a way to log the error details of the package if the package fails.

By error details I meant something like the information displayed in the Output window when a package is run on BIDS.

Thanks.
thomaszhwangAsked:
Who is Participating?
 
Barry CunneyConnect With a Mentor Commented:
When designing the SSIS package in BIDS you can configure error logging:
http://msdn.microsoft.com/en-us/library/ms167456.aspx
0
 
thomaszhwangAuthor Commented:
Thanks.
0
All Courses

From novice to tech pro — start learning today.