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? 2 5509
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?
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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Scott Tilton |
last post by:
I am having a terrible time getting this to work. I am hoping someone out
there can help me with very specific code examples. I am trying to get the
linked tables in my Access 97 database to be...
|
by: Steve Jorgensen |
last post by:
Hi all,
I've just finished almost all of what has turned out to be a real bear of a
project. It has to import data from a monthly spreadsheet export from another
program, and convert that into...
|
by: Peter Afonin |
last post by:
Hello,
Our SQL server used to run under System account, and I had no problems
executing DTS packages from the ASP.NET:
Dim oPkg As DTS.Package
oPkg = CreateObject("DTS.Package")...
|
by: Vishal |
last post by:
Hello,
I need to import data from a excel file into a SQL
Server. I would like to provide an asp.net interface for
that purpose. What would be the best to do that? A simple
textarea where the...
|
by: Rob Hughes |
last post by:
(This is a crosspost from .data for greater exposure)
I am writing an external app that utilizes. The app needs to be able to run
repeatedly, but I am having a problem because Access will not...
|
by: Mark S |
last post by:
I'm basically a database noob hoping to find a shortcut if at all possible.
I've created an ER diagram for a site I plan to build and have used that to
create the database in MS SQL 2000.
Now...
|
by: dancer |
last post by:
Using ASP.net 1.1 and Microsoft Access.
I received the following error message. Why? I have closed the Access
file. I have another very small access file that opens with no trouble with
the...
|
by: provor |
last post by:
Hello,
I have the following code that I am using when a user presses a button to import an excel file into a table. The code is hard coded to point to the correct table. This works great for this...
|
by: cvalle |
last post by:
A little about me... I’ve build a few Access dbases but I consider myself a novice. I have never inherited someone else’s Dbase. The dbase is not password protected, but I cannot access all of the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |