January 29, 2014 at 12:46 am
Hi ,
I want to Log an error into my Error Log table where we Can Log the Errors in the Tasks and Data Flow task related using the Event Handler On Error option . But i am unable to get solution for one of my Problem so i was expecting Help you Experts
In my Data Flow Task if i have got the Wrong entry of Server Name or Table Name , the Error should get logged into my Table . I have defined the Event Handler for the Data Flow task but (this is not working) , When i am Executing the Package , the package is first getting validated and due to the Error in the Data flow task it is not getting Executed and throwing the Error . What i was expecting is to Log that Error through that DFT Event Handler created .
I Know that we can get the Error though the "Logging " option on the right click of the package , but i want tthe Error getting logged through the Event Handler . Please Kindly respond and provide some suggestions .
Thank You .
January 29, 2014 at 12:50 am
What if you set DelayValidation to true on the package and the data flow?
That way the connection is validated when it is used for the first time (probably when the data flow starts).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 29, 2014 at 2:24 am
Koen Verbeeck (1/29/2014)
What if you set DelayValidation to true on the package and the data flow?That way the connection is validated when it is used for the first time (probably when the data flow starts).
Thanks Brother. it really made the Trick 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply