Problem whene extracting data from dBase IV.. -
10-13-2003
, 08:52 AM
Hi,
SQL Server 2000 SP3
Windos 2000 Server SP4
I have a DTS package to imports data from a dBase IV
databse with files located in two folders (dBF1 and dBF2).
I use a transform data task to transform the data.
They were running properly, but last week we installed W2K
SP4, and now the transform task for files from dBF2 are
not working properly.
I have two tranform tasks to extract data from files in
dBF2 folder. If I double click to open the trensform data
task of either of them, Enterprise Manager crashes with
the errror
mmc.exe applicatio Error
The instruction "xxxx" referenced memory at "xxx". The
memory could not be read.
Althoug the transform task for one of the files will run,
the other will not run giving the message
Error Source: DTS package
Catastrophic failure
Also, I have an Access database that has links to the same
dBase files. For files from dBF2 folder, I'm able to see
the data from one of the files, but if I double click to
see the data from the other, access crashes with no
specific error message. Nothing has changed on dBase
related files (permission wise).
The transform tasks to extract data from the other dBase
folder (dBF1) files are working fine, and data is
accesible from Access.
Any advice how to tackle this one? |