Hi,

I am trying to import a .dbf file using the DTS wizard. I specify the directory and it finds the file I want. But when I try to start the import it says the object is not found.

Any ideas?

Denis

What is the exact error you are getting?

Rand
This posting is provided "as is" with no warranties and confers no rights.

Here we go:

Error Source: Microsoft Database Engine

Error Description: The Microsoft Jet Database engine could not find the object 'my_object', Make sure the object exists and that you spell its name and the path name correctly.

Context: Error calling OpenRowset on the provider.


"Rand Boyd [MSFT]" wrote:

Hi Denis,

1) Make sure that the dbf file exists in the path you specified and make
sure that you are able to open that file from file system.
2) Are U able to run the package from EM? (Is that giving the same error to
U)

Thanks
Prabhat

"Denis Crotty" <DenisCrotty (AT) discussions (DOT) microsoft.com> wrote

and the path name correctly.

Hi,

The file does exist and I can open it, but it is not a dBase file, but rather a part of a shape file. I am running the package in EM, so that is where I'm getting the error.

Denis

"Prabhat" wrote: