I need help in finding account lock out issue.
I have an SSIS that connects to IBM DB2 as a Source. It loads data into SQL every day. The IBM DB2 account that we have been given has a password expiry policy set to X days and after X days once the password expires the SSIS starts failing. I am using save sensitive information with the password option to save the password. The problem I have is once I get a new password I try to open the SSIS and that locks the account again (due to validation using the old password). I have to contact IBM DB2 BDA to reset the password. I have multiple SSIS and co-ordinatiing the password change is becoming a nightmare.
Can I use config files? If so how. Any help is appreciated.
Thanks
Sreejith