Get the password used in a SQL Job that launch an SSIS password protected package
On MS SQL Server 2008 R2 (and maybe other versions) :
Simply right-click on the job and select the option Script Job as > CREATE To > New Query Editor Window
The password will be written in the SQL query.
Simply right-click on the job and select the option Script Job as > CREATE To > New Query Editor Window
The password will be written in the SQL query.
Comments