Also, you might look into the Transform Data Task Properties - Option tab. It has a couple of features that deal with errors during a transform. Click the help button for that tab. Specifically I'm referring to the "Max Error Count" and "Insert Batch Size" which in combo allow a certain number of errors to occur while still commiting the remainder of the records. It may not be the best way to go for you, but it is another option.