Hi All

I am trying to copy data from DB2 to SQL server using SQL Data
Tranformation Services.

I am able to do that by supplying AS400 username/password along with
the iSeries DSN Name, at the time of data retrieval from DB2 database
tables to SQL Server.

Problem is i have 20 different DTS packages, and if i change my AS400
password then i have to change the password in all the 20 packages.

I have looked at the option of setting the 'use windows username
option' in the iseries navigator and that works fine as long as the
windows username/password are the same as AS400 username/password. But
the problem comes in when you change the as400 password but do not
change the windows password or vice-versa.

Is it possible to set up a user account/password information in ISeries
Navigator only and change that as required, without the requirement of
also changing the windows password.

I will highly appreciate a response.

TIA