ESP Workload Automation

 View Only

 ESP & Password-protected SSIS package (SQL Server)

Brandie Tarvin's profile image
Brandie Tarvin posted Dec 10, 2024 02:39 PM

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?