This is more of a sql question then an HP one but I was hopeing someone could help me out... I'm using an SQL DTS to transfer some database tables to an SQL server. I've transfered most of them but a few of them are getting errors. This is an example of a typical error: ________________________________________________________ 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 then this error message. I have 3 with numeric(8,0) as the datatype for me.. I copied that error message from a newsgroup post I found while researching this error message. Their only advice 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 outany 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 ===== Listen to Gehan's personal internet radio station: http://launch.yahoo.com/lc/?rt=0&rp1=0&rp2=1218561385 __________________________________ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *