Error importing from AS/400 library -- sql server dts

Antonio Giossa
2/26/2004 11:33:23 AM

I am trying to import some files located in an AS/400
library. I use Mochasoft to connect my Windows 2000 Server
to the AS/400 library through a ODBC connection.

The ODBC connection works fine. I use it from MS Access to
import the AS/400 tables and the import job works fine.

When I use the same ODBC connection to import to a SQL
Server 2000 database, I can see the tables from the AS/400
(to select them) in the "Select source tables and views"
but I can not import them or make a preview of its data.

I allways receive this error message:
DTS IMPORT/EXPORT WIZARD ERROR
Unexpected error ocurred. The provider has returned an
error result without the error message.

Anybody had the same problem?

Thanks in advance,

Antonio Giossa

frydendal NO[at]SPAM mochasoft.dk
3/1/2004 4:49:56 AM

The Mochasoft product does not include any ODBC support.

MochaSoft support,

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Error importing from AS/400 library