Capturing Error info when execute SQL task fails.

[Kiran V]

Hi ,
I have a execute SQL task doing a SQL updation. I deleted the table its updating and ran the package. And i was watching the Execution results tab. How to capture the exact text that is being displayed in the Execution results tab.

[Bob Barrows]

Post by Kiran V
Hi ,
I have a execute SQL task doing a SQL updation. I deleted the table
its updating and ran the package. And i was watching the Execution
results tab. How to capture the exact text that is being displayed in
the Execution results tab.

Where do you wish to capture this? Do you want your package to log it
somewhere? You can turn on Logging and configure it to only log ONError
events.