error importing from AS00

[Logan]

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

[Erland Sommarskog]

Re: error importing from AS00

[posted and mailed, please reply in public]

Logan (logan1577@hotm ail.com) writes:[color=blue]
> 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 ???[/color]

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.publi c.sqlserver.dts where the
really sharp DTS people hang out.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp