var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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..
If you insert it as a chracter datatype then you can check the value and correct it.
You could also probably use an activex script on it but that would be slow.