Share SSIS Packages / projects between users

Question

I have a bunch of SSIS Packages I created. They are all saved to an SSIS Project in the file system. I just hired another employee and would like for him to be able to execute my packages. I gave him access to the folder where I store the packages (it is on my OneDrive). He can open the project in VS, but when he attempts to execute the package, he gets a slew of errors (see screenshot). Is it because it is on OneDrive? What is the best way to set up an environment where we can store the project (and all the packages) and BOTH use it?

Answer 1

Hi @Dom,

First, you need to change ProtectionLevel setting to DontSaveSensitive value. It shall be done on two levels:

• VS SSIS Project level
• Every single SSIS package.

Please see below.