 | |
Re: Execute SQL Task Error Capturing
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Execute SQL Task Error Capturing -
07-06-2004
, 12:02 PM
|
I did figure out that when running the tasks manually the progress window that stays open when done does contain the messages associated with the tasks. Is there a way to access that object? "whornak" wrote: I want to build error capturing and reporting into the DTS packages. I am currently using 'Execute SQL Task' and sending emails when the SQL Statement fails. What I want to do is provide the recipient with as much detail as possible about the error. How would I capture the actual error messages when a statement fails? |
Use GetExecutionErrorInfo method for the step, but this is only an
option in strong typed code, such as VB, not VBScript.
Execute package WithEvents and capture the OnError events.
Log errors to a file, package level option. Note error file is not
available during the current package execution.
Log errors to SQL Server, package level option. You can access the
current execution by using the lineage Id global variables, see package
level option. Still probably done easier post execution or in a parent
package.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.