Is there a way to write the error that caused a SQL Server job to fail inside of the email it sends out when there is a failure. Currently the email i receive has some info and tells me the last step to run and that it failed but I want it to give the error that failed the individual step.

SSIS has two system variable System::ErrorCode and System::ErrorDescription, You can use these variables in Send mail task. So when your package will fail then email will be send with Error Code and Error Description. Thankshttp://sqlage.blogspot.com/

That is one of my options , but that would require going back to a lot of packages and editing them. I was hoping for something that I could use on the job which contains multiple packages at once. If I have to go back to each individual package I can but I was wondering if there was some way to use the email to the operator to help out.

In each Agent Job, you can go to the Job Step that runs the SSIS package. On the Advanced tab, you can specify an Output File which you could attach to an email. This ought to have a little more information in it... Talk to me now on