467,877 Members | 1,085 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

Login to AS400 from SQL Data Transformation Services

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.


Nov 12 '05 #1
  • viewed: 1470

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Niyazi | last post: by
1 post views Thread by cfyam | last post: by
1 post views Thread by Jo Blow | last post: by
13 posts views Thread by Sehboo | last post: by
4 posts views Thread by Brad Allison | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.