I am trying to configure my sql to import records from an as400 file. I know:

the as400 address
the as400 name
the library the file is in
the file name
the file structure

When I run the DTS wizard, and do a test connection it is giving me an error of partner LU alias problem.

Would you please post the exact error message (or a screenshot of the error message)?
========================================
Buh Bye!

Cheers,
Me

Using the DTS import and Microsoft driver OLE DB

Data Source: (used the server name) and tried the (server IP address)

Location:(library name) and tried (library name . file name)

when clicking on test connection error message is:

Test connection failed because of an error initializing provider. Invalid partner LU alias.

Using the DTS import and IBM driver OLE DB

Data Source: (used the server name) and tried the (server IP address)

when clicking on test connection error message is:

this passes the test so I go to the next window it prompts me to enter name a password

Error source: Microsoft OLE DB Provider for AS400 and VSAM

Error description: Invalid partnet LU alias

Context: Error during initialization of the provider

CU