ssis Connection manager password ("DontSaveSensitive")
- by swapna
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