Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Starlet_GT
Yak Posting Veteran
81 Posts |
 Posted - 2009-07-16 : 02:48:12
|
| Hi,I want to assign value in a variable which contains password string, but problem is that the package will be running over remote server and other developers access the same server. I don't want to disclose my domain password to others ... What is the right way to keep my password in a SSIS package and on the other hand no body can see it.Thanks MIZ |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-07-22 : 10:07:28
|
| Read up on EncryptAllWithPassword protection level. It encrypts the package so your variable is not clear text. It's not 100% secure but something. |
 |
|
|
|
|
|
Store Password in SSIS Package