Menu Items

Tuesday, 20 March 2012

Can you configure the security of a package so that you can store a password in clear text in the underlying .dtsx fi le in the file system?

Ans. no, sensitive information such as connection passwords cannot be stored as clear text in the package fi le in the fi le system. The only way to store the connection password in the fi le is to encrypt the sensitive information by setting the ProtectionLevel to EncryptSensitiveWithPassword or EncryptSensitiveWithuser- Key. A better choice is to set the ProtectionLevel to DontSaveSensitive and use an SSIS confi guration to store the connection password.

No comments:

Post a Comment