All geek questions in one place

SSIS Package Permissions

When I set permissions for the SSIS package (ProtectionLevel), and I enter the Package Package, then when I open the package on my computer, it does not ask me for a password.

Am I doing something wrong?

+3
source share
2 answers

You are probably not mistaken. Here are some things I've learned about SSIS package security:

If you set the Package ProtectionLevel property to EncryptSensitiveWithPassword and specify a password, the package will behave as you described - if and only if nothing is considered “sensitive” in the package. Essentially, this parameter is ignored (although the property parameter is saved) until something appears that SSIS considers "sensitive."

SSIS , . , . Windows, . SQL-, , EncryptSensitiveWithPassword ( - ). ( Windows, / ... , ...)

SSIS-, EncryptAllWithPassword ProtectionLevel. , -, - - .

, .

: { >

+7

@ Andy Leopard , . , - , PackagePassword . , .

+1

Source: https://habr.com/ru/post/1714056/

More articles:


All Articles