Data Warehouse

[SSIS]

Questions:

Notes:

What are the properties of Package Password Protection?

 All of the security options are controlled by the protectionLevel property. With the package open in the package designer, you can use the Properties window to set the ProtectionLevel property to one of the following values:

  • DontSaveSensitive
    • Removes passwords and other sensitive information from the package
  • EncryptAllWithPassword
    • Encrypts all package contents by using a password
  • EncryptAllWithUserKey
    • Encrypts all package contents using a key based on the current Windows user. Only this user will be able to open and make changes to the package.
  • EncryptSensitiveWithPassword
    • Encrypts only passwords and other sensitive information in the package by using a password.
  • EncryptSensitiveWithUserKey
    • Encrypts the entire package by using a key based on the current Windows user. Only this user will be able to view sensitive information. Another user can modify the package, but sensitive information will not be displayed.
  • ServerStorage
    • Encrypts the package contents stored when the package is deployed to SQL Server. The encrypted package is stored in the MSDB system database. This option is supported only when a package is saved to SQL Server. Access to the package is controlled using SQL Server database roles.

What is the difference between Push and Pull Deployment?

 Push deployment is when you push a package into a server by running the Package Installation Wizard.

Pull deployment is when you import the package from within SSMS.

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *