Package password update in SSIS

Sometime we need to provide SSIS solution to the different developers or team members. When the team member or developer try to run the SSIS package will be failed, because package password and user sensitivity information will be saved to the package. To avoid this you should following steps.

Steps:

1. Open SSIS project.

2. Select packages you wanted to run by the team members/ developers to run the SSIS package.

3. Select the SSIS package and go to the package property(by pressing F4). You will see package property as follows.

4. By default, ProtectionLevel is set to “EncryptSensitiveWithUserKey”. Change ProtectionLevel from “DontSaveSensitive” and you will the screen as follows.

5. Save SSIS package and Run the package in any machine with any login ;-)

My First Blog post

All,

I would like to share my learning and findings in my work experience on Microsoft BI technologies and System integration using Microsoft BI. Your comments and views will help me to improve and share ideas on MS BI.

Thanks,

Gowdhaman