Send Email Task - Error Reporting

Hot Topic

Error in the login process when establishing connection
Package from Package Sore does not work as Job
Sql Server Agent cannot run a package
Web Synchonization Performance & Concurrent Users
SQL 2005 Database Engine setup failure
Check if database exists?
for loop container to process all Excel files
Sign a document by SmartCard on the .NET client and verify on the SQL 2005 server
Backup of tables
change column names

SQL Server

RowNumber in Report builder?
MS SQL Server Language Support HELP
dtexec
Changing Column size/type with Derived Column
SQL Server 2005 Express: Weird error message running SELECT COUNT query
Maintaining Security
Subscription cannot be found
Can't find microsoft.sqlserver.execpackagetaskwrap.dll in Sept CTP
Can not change filter on model report - UPDATED 7th June
Cannot install 'SQL Server 2005 Express Edition with Advanced Services'

Send Email Task - Error Reporting

SSIS : I have a "On Failure" precedence constraint that executes a Send Email Task for a Data Flow Task. Do you know how I might capture the error message from the Data Flow Task to include it in the Email (most likely as a variable)

Thank you for any help!

-Tim

Answer this question

Send Email Task - Error Reporting

Moldavia

Put the send mail task in the OnError eventhandler for the data-flow. The error message will be available in @[System::ErrorDescription]

-Jamie
Send Email Task - Error Reporting

Answer this question