July 28, 2009 at 10:29 am
I am loading a data from source to destination, suppose if I need to load a million records and if an error occurs in any one of the row, the whole package fails, instead i want to skip that error and continue data loading so package doesnt fails. how do i do that.
July 28, 2009 at 6:05 pm
How are you loading the data? Data Flow, Bulk Insert or something else?
July 28, 2009 at 8:16 pm
In many cases in the Dataflow you can catch a bad row by configuring an error row output, after you drag the red output to its path you need to set the fail action in the source.
Clear?
CEWII
July 29, 2009 at 9:24 am
There are a couple of articles here on SSC about this, one of which I wrote. They both also show you how to log the error to a table. Here's a link[/url] to the latest one which contains a link to my article.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply