By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,651 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Login to AS400 from SQL Data Transformation Services

P: n/a
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

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.