Add 6,000 records to table with existing records

[cyberbob2]

Hello,
When I try to insert records from table 1 into table 2, I get the following error:

DTSTransformCopy: Schema validation filed; see Extended Error information.
TransformCopy 'DirectCopyXForm'validation error: Cannot convert (possibly due to type or length mismatch) column pair 7 (cource column 'StoreNumber'(DBTYPE_14), destination clumn 'fldLastHit'(DBTYPE_DBTIMESTAMP)).

However, when I do a direct copy and paste from table 1 to table 2, there's no problem. However, in Enterprise Manager when I try to copy and paste more than say, 20 records, it takes a very long time and sometimes times out.

Any suggestions and advice would be appreciated.

Thanks,
KP