SSIS - Granting access to Developers

Question

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.

Answer 1

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 :

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.