Hello,
I try to send data from sqlserver 2000 to a remote DB2 as400. The AS400 is
connected with a dedicated line. Now, if i run the DTS package from
Enterprise Manager all is ok. If i run the same package from Query Analizer
or from my application programm it never goes to the end. No response is
given by the DTS.

This is the instruction:

EXEC OD_EXECUTEPACKAGE Server, Package name, User, password

Does anyone know what happen? In which way can i resolve the problem ?

Thanks.

Marco

Have you checked the login settings for SQL and DB2? This sounds like you
might have integrated security set. When you are running under SqlEM, you
are interactively running the DTS task under your userid. When running from
the application or Query Analyzer, you are running as a different user
(most likely the same one configured for SQL Agent or if the application is
IIS you are probably looking at the IIS user.


"Marco" <marco.divenuta (AT) omniadata (DOT) it> wrote