ssis Connection manager password ("DontSaveSensitive")

Question

Hi,

I have a SSIS package used the protection level as "DontSaveSensitive" So initially i have saved the oledb connection manager password as in a XML config file.And this worked fine for me.

Now for business requiremnt i have stored the configuration in sql server. Including password.

Initially it worked fine.But suddenly connection manager is not taking password from sqlDB.

If i set an environment variable for the "password" it's working.

My question is. 1) what is the solution for this.( i can only save the configurations in sql) 2) initially how it worked.I mean initailly from sql server the password was taking.

Please give some clue.I am doing a lot of trial and error.

Thanks

SNA

Answer 1

How are you going to retrieve the password from the database if you need the password to connect the database?

There is a small article here about storing passwords which may help you.