How to Protect SSIS Package

Опубликовано: 01 Март 2015
на канале: Mayank Sanghvi

4,136

How to Protect SSIS Package

This video is about how to use Protection Level SSIS Package property to protect sensitive information in your SSIS Package.

Options in Protection Level Property
•Do not save sensitive data: When you select do not save sensitive data, SSIS package is not going to save any sensitive information such as password in your SSIS Package.
•Encrypt user data with user key: This is the default when you create a new project and SSIS Package. This method is encrypt all the sensitive information with user key. It is not recommended if you want to share your package with other team members. The reason behind this is the sensitive information is saved with your user key or with your login and no other person can able to access this information with their login. Also it will cause lots of re-work for other team to re-modify your given SSIS package to execute it properly.
•Encrypt sensitive data with password: You can select this option when you want to share your package within multiple teams. All your sensitive information is encrypted with a password. Password is required to open a such type package.
•Encrypt all data with user key: This option is not recommended if you want to deliver your package to other team members. When you saved your SSIS Package with option encrypt all with user key, your entire SSIS package is encrypted with your user key or login. Now no one will be able to access this package without your login.
•Encrypt all data with password: Encrypt all data with password is used to encrypt entire content of SSIS package. No one able to open the package without using password.

Смотрите видео How to Protect SSIS Package онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Mayank Sanghvi 01 Март 2015. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 4,136 раз и оно понравилось 25 посетителям.

644