How would one go about writing a DTS package that would
take a flat file and load a database table but selectively
takes records based on the data.
Currently I have a CSV Flat file that has basically say
10,000 records. Daily I get a new flat file with a new
set of 10,000 records. This flat file occassionally
contains some bad data on a handful of records, say 10-
20. Is there a way to process the 10,000 records, and
skip the 10-20 records that are bad? The bad records are
easy to identify, since all the fields are blank.