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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Store Password in SSIS Package

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.
Go to Top of Page
   

- Advertisement -