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.

Comments

Popular posts from this blog

Resolve "Cannot download packages whilst offline" issue in Deja-Dup backup software

ubuntu 20.04 / netplan / change mac address and static ip

wireshark ssh remote connect on linux server