September 14, 2011 at 8:17 am
Hi ,
I have created a package which has data flow task ,the data comes from Access database and some dataconversion and goes to destination table. I would like to know the error if the datatype in access changes or column name changes. How can i capture that.
Sudheer
September 14, 2011 at 2:42 pm
hi you can handle errors in SSIS by going to event handler tab and from there you can capture error code, error description for any event you select .
September 15, 2011 at 8:57 am
Check out this article[/url] as it may apply to your situation. The issue with using an event handler to log the error in a Data Flow is that the data flow will fail (unless you change the max errors). The solution in the article allows all the data that does not fail to be loaded. It is up to you how you handle it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply