By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,606 Members | 2,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,606 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Jul 20 '05 #2

P: n/a
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?

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.