I am trying to add the connection parameters Encrypt=True and TrustServerCertificate=True to connection strings in various SSIS packages.
All the connections are defined as package parameters, and all the parameters have Encrypt=True;TrustServerCertificate=True;
but when i execute the package in VS2022 all the database connections are not encrypted.
When running on the SSIS server, I use Environment variables to set the connections string and have added the parameters there, but when i execute the package on the SSIS server, the connections are also not encrypted.
Is there something I should be doing in the Package, Solution, or Environment to enable usage of these parameters?