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

Post a Comment

Popular posts from this blog

Connect the Xiaomi Yi Ants Cam to your Synology Surveillance Station

1) Ensure the current firmware of your cam allows you to see the steam without authentication. You can check this using vlc and connecting to rtsp://192.168.1.128:554/ch0_0.h264 If you are able to see the stream, you can go to the next point. Otherwise you have to downgrade the firmware of your cam : Simply place this file on the root of an SD card, insert the SD card in the cam and reset it (a reboot may be sufficient) 2) Create the following file on your synology using putty /volumeX/@appstore/SurveillanceStation/device_pack/camera_support/Xiaomi.conf with this content: [Xiaomi*Ants] api = custom resolution_h264 = 1280x720 default_resolution_h264 = 1280x720 fps_h264_640x480 = 5,10,15,20,25,30 fps_h264_1280x720 = 5,10,15,20,25,30 default_fps_h264_1280x720 = 10 default_image-quality = 5 h264 = rtsp mpeg4 = rtsp mjpeg = rtsp motion = h264,mpeg4,mjpeg motion_param = sensitivity,threshold rtsp_keepalive = none rtsp_protocol = auto,udp,tcp 3) In the surveillanc...
Read more

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

If you got the error message "Cannot download packages whilst offline" but your internet connection is active, this is probably because you've managed the network configuration yourself and the network manager is reporting an offline status even if it's not correct. To fix this issue, simply edit the file /etc/NetworkManager/NetworkManager.conf and change the following configuration to be inline with: [ifupdown] managed=true Then restart the Network Manager : sudo service NetworkManager restart #1
Read more

TXT_DB error number 2 failed to update database

As I m completly unaware of the openssl use, I only write here some observations I made : If after the command : openssl ca -out cert.pem -infiles req.pem you got the following error message : failed to update database TXT_DB error number 2 This is probably because you have generated your own signing certificate with the same Common Name (CN) information that the CA certificate that you've generated before. Simply input a different Common Name each time you are asked should do the trick. Credit : 1
Read more