SSIS - Granting access to Developers

user_8956724 0
Viewed 43

My current ELT process is done via an SP. I am new to SSIS and trying to replicate this process using SSIS.

I have created a set of extraction packages in visual studio, but my team members cannot access the control / data flows and are unable to save the changes.

In order to allow my developers to access my packages and deploy them, how would I grant them access?

I have tried changing the security settings but that doesn't seem to work.

ssis visual-studio package
1 Answers

As @Filburt mentioned in comments, this is because the default protection level, which is set at project level.

In Visual Studio you can right click on the Project and select Properties. You will see a section Security :

enter image description here

and there you can select a different protection level, for example "Do Not Save Sensitive Data" or "Encrypt Sensitive Data With Password", in which case you need to set a password and share it with your team members.

enter image description here

enter image description here

user_29649630
Related