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?
The discussion continued in this post