Thread: DTS Error
02-08-02, 02:07 #1Registered User
- Join Date
- Feb 2002
Unanswered: DTS Error
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..