Prev: Simple Round call results in Arithmetic overflow
Next: fn_listextendedproperty
From: CLM on 29 Jul 2010 15:20
I'm a relative newbie with SSIS in SS 2005. I have learned some of the basics
about logging using SSIS, but I cannot figure out how to log a bad record.

In other words, let's say I've got a text file with a 1,000 records and 2 of
those records are bad and can't be loaded. I'd like for 998 to go into the
table and the 2 bad records to get written out to another file for inspection
later.

Is this possible? If so, how can I do this?
From: Eric Isaacs on 29 Jul 2010 15:56
Load the data into an intermediate table before it is loaded into the
final table. Then you can handle the invalid rows separately.

-Eric Isaacs
 | 
Pages: 1
Prev: Simple Round call results in Arithmetic overflow
Next: fn_listextendedproperty