Cannot import/link data from dBase with SQL Server DTS nor Access anymore..

[Ivan]

Hi,

SQL Server 2000 SP3
Windos 2000 Server SP4

I have a DTS package that 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 transform 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?

[John Bell]

Hi

This sounds as if the file is corrupt in some way. Can you open it and run
the dBase tools against it?

John

"Ivan" <i.*******@warwick.ac.uk> wrote in message
news:2b**************************@posting.google.c om...

Hi,

SQL Server 2000 SP3
Windos 2000 Server SP4

I have a DTS package that 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 transform 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?

[Ivan]

Thanks John for your reply,

The dBase files are fine. They are from the CRM application. Also,
They are all accesible from an NT 4 workstation with Access 97.

I wonder if it's the jet 4 files the ones are corrupt.. not sure if I
should just install jet 4 SP7 again. would the previos isntallation be
overwritten? is it possible to install a lower version of Jet 4 on a
Jet 4 SP7 isntallation?

I can't unistall W2K SP4 and go back to previous OS state as I didn't
archived the files....

Thanks,
Ivan

"John Bell" <jb************@hotmail.com> wrote in message news:<3f*********************@reading.news.pipex.n et>...

Hi

This sounds as if the file is corrupt in some way. Can you open it and run
the dBase tools against it?

John

"Ivan" <i.*******@warwick.ac.uk> wrote in message
news:2b**************************@posting.google.c om...

Hi,

SQL Server 2000 SP3
Windos 2000 Server SP4

I have a DTS package that 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 transform 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?