Password Issue

Hi All,

We are developing a package in SSIS where we are using a connection to Mainframe AS/400 using ODBC. The problem is that when we fill in the User ID and Password and check the remember password textbox this seems not to be taking effect.

What this triggers off is that whenever we open the package a NULL password is sent to the AS400 server and it locks the ID.

Any ideas what to do

Manish

By default, password is not stored in the .dtsx file. You should search BOL for ProtectionLevel property.

-Jamie

|||

I don't belive teh DB2 provider stores passwords. Not used it, but seen plenty of posts about it doing this. I'd say this is not a problem, and agree with jamie, you don't want to save sensitive data anyway.

The better solution alll round is to use Configurations. They help with deployment issues, but work perfectly well in development as well. See SSIS - Configutaions menu, and have a read in BOL.

|||

Hi,

We tried the configuration option, putting the config data in a SQL Server table. It works fine. But if we copy the job and rename it and try to open it, it again locks the id:)