Hi,
Can any body help me to sort out this problem

I am running a DTS package source as dbf file and destination as sqlserver database the following error occurs

for row number 2035 errors encountered so far on this
task 1. insert error, column 3 ('arch_dt', DB_TYPE DBTIMESTAMP)

when i was opening dbf file in foxbase its showing (arch_dt field) date as datatype the same when i was importing to access the datatype is changing to text type.

so daily manually i am opening in excel file and delete the records where the line error occurs.

in excel file that particular row will have some text format instead of dateformat.

how can i solve this error without manual interaction..

with regards
rajkumar