tailieunhanh - Microsoft SQL Server 2005 Developer’s Guide- P43

Microsoft SQL Server 2005 Developer’s Guide- P43:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 10 SQL Server Integration Services 399 Package Security SSIS packages can contain sensitive authentication information and saving those packages opens up the possibly of a security exposure. To protect against this possibility SSIS supports the encryption of sensitive information. SSIS uses the Triple Data Encryption Standard 3DES cipher algorithm with a key length of 192 bits and packages are encrypted either when they are created or when they are exported. SSIS package encryption is controlled using the package s ProtectionLevel property which supports the following values ProtectionLevel Value Description DontSaveSensitive Sensitive data is not saved in the package. When the package is opened the sensitive data will not be present and the user will need to provide the sensitive data. EncryptSensitiveWithUserKey Sensitive data is saved as a part of the package and is encrypted with a key that s based on the user who created or exported the package. Only that user will be able to run the package. If another user opens the package the sensitive data will not be available. EncryptSensitiveWithPassword Sensitive data is saved as a part of the package and is encrypted with a usersupplied password. When the package is opened the user must provide a password to access the sensitive data. If the password is not provided the package will be opened without the sensitive data. EncryptAllWithPassword The entire contents of the package will be encrypted with a user-supplied password. When the package is opened the user must provide the package s password. If the password is not provided the package will not be able to be opened. EncryptAllWithUserKey The entire contents of the package will be encrypted with a key that s based on the user key for the user who created or exported the package. Only the user who created the package will be able to open it. ServerStorage The package is not encrypted. Instead the package s contents are secured according to the database s .