May 8, 2009 at 9:13 am
I have a Data Flow Component that is an Oracle Destination table.
On error I have it go to a Script Component and make a Derived Column. My question is:
within the script is it possible to access the Properties data from the Data Flow Component?
For example if I wanted to access the Name of the Data Flow Component in the Script following the Error Output... is this possible?
May 15, 2009 at 4:46 am
Is this being handled by the OnError Event handler?
If so then there is the System::SourceName variable which holds the name of the control flow item which caused the error.
as far as I know there isn't a way to reference the name of the data flow component.
August 20, 2009 at 3:51 pm
there is a event called OnFailure. You will find the option of task name and souce name under it. that will give you data flow component name.
August 24, 2009 at 12:00 am
When using just the script component in the dataflow I don't believe this data is readily available. It may be available if you write a custom data-flow component. But that is somewhat involved..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply