Automatize Integration Services Project Password for Visual Studio Solution

Question

I have a Visual Studio solution with multiple projects and they use the protection level: "Encrypt sensitive with password", so every time that the solution is loaded I have to enter the password manually for each project.

There's a way to automatize this? passing the password via command line when I open the solution or something like that?

The password is the same for all projects.

Thanks in advance.

Answer 1

The Visual Studio application is called devenv.exe (SQL Server Data Tools is included), And according to MSDN - Devenv Command Line Switches, there is no command line that can be used to achieve your goal. Simply disable the encryption if it is disturbing you.