Hi,

based on experiences I'd like to understand better when it is appropriate using environment variables in the SSIS catalog and the project parameter, thinking to obtain some best practices to manage the deployment phase and the prod environment.

I'm trying to create environment variable to parameterize SQL server connection string and the corresponding password to access by two separate variables. In particular, in the SQL Server connection string I need to write a SQL Server login.

Sometimes it occurs login failed error for jobs that call SSIS packages in the catalog and use the related environment variables.

Have you experienced with the environment variables of the SSIS catalog to parameterize SQL Server connection string and password (handled as a sensitive data)?

Thanks