Managing errors with a Event Handler
-
I got some dataflow within a control flow.
The thing i want to do is to get some information through a event handler about errors that can happen during the execution of the control flow.
How can i get these informations, with which control flow item (i mean, like error code, package id, taskname in error, etc...)?
How can i save these error information into parameters or variables, so i can use them later, for example in order to
store them into a database?
Thanks
-
The OnError eventhandler contains the information that you mentioned in the following variables:
- System::ErrorCode
- System:
ackageID - System::SourceName
plus others such as
- System::ErrorDescription
- System:ackageName
- System::SourceID
- System::SourceDescription
So you have no need to save them anywhere. Once inside the eventhandler you can do what you want with these values, including storing them in a DB table.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
Which component I have to use in the eventhandler ?
-
What do you mean? To do what?
You can use whatever you want in an eventhandler?
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
I would like to do a SQL request with an "Execute SQL task" and put inside parameters that we talk about before.
I don't know how to declare these parameters and how to use them in an "Execute SQL task"
-
There is no requirement to "declare" these variables. They already exist within the package. Have you looked in the "Variables" pane when inside an eventhandler?
If you want to use them in an Execute SQL Task then you can either:
1) Use parameters
2) Build your SQL statement dynamically as explained here in an example: http://blogs.conchango.com/jamiethomson/archive/2005/02/28/1085.aspx
I recommend option 2.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply