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

error importing from AS00

P: n/a
I am trying to transfer with dts a table of As400 into a db sql-server.

But i receave un error (2147217865)

With Access i can import the table with the same ODBC.

You have some suggestion ???

thk by Logan bye bye

Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
[posted and mailed, please reply in public]

Logan (lo*******@hotmail.com) writes:
I am trying to transfer with dts a table of As400 into a db sql-server.

But i receave un error (2147217865)

With Access i can import the table with the same ODBC.

You have some suggestion ???


There wasn't an text with the error message? You are terribly short on
details, but since I don't use DTS nor know anything about connecting to
AS400, I would not be able to say that much more.

However, I did look up the error code in a book I have, and if the error
comes from the OLE DB provider, the error is "The specified table does not
exist". Whether that refers to the table on the AS400 side or on the
SQL Server side, I don't know.

You probably need to add some deubgging to your DTS package. As I
mentioned I don't use DTS myself, so I cannot really help. But you
could check out the group microsoft.public.sqlserver.dts where the
really sharp DTS people hang out.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.