I have a table that's transferring from an HP 3000 image database via
minisoft odbc driver.

I downloaded about 20 tables but I have 4 that are getting errors like:

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error
Description:The number of failing rows exceeds the maximum specified.
(Microsoft Data
Transformation Services (DTS) Data Pump
(8004202c): TransformCopy 'DTSTransformation__1' conversion error: General
conversion
failure on column pair 1 (source column 'REG_BEG_DT' (DBTYPE_DBDATE),
destination column 'REG_BEG_DT' (DBTYPE_DBTIMESTAMP)).) Step Error code:
8004206A Step Error Help File:sqldts80.hlp Step Error Help Context ID:0

Only mine are different fields and datatypes, 1 timestamp, and 3
numeric(8,0)null for me

I copied that error message from a previous post I found while researching
this error message.
Their only advice to him was that this stems from bad data, maybe a letter
where sql expects a number
or what not. And their suggestion was to look though the data and clean out
any bad data..

My problem is these tables have between 1 and 10 million records..
It would be impossible for me to go though them by hand..

Does anyone have any way I can get these tables to transfer, is there a
"drop record on error and continue option" that I'm missing?
Any help would be much appreciated,
Thanks,
Gehan Gehale