I am a SQL Server DBA who is helping some team members move SQL Agent jobs to ESP. One of these jobs includes a SSIS package that is password-protected. The package works fine in SQL Agent, but I am being told by someone that the package cannot be run in ESP because of the password-protection.
Due to security reasons, we require the password protection on the package.
Does anyone know how we can resolve this situation without removing the protection on the SSIS package?