26 March 2014

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.

No comments: