Decrypt DTSX file

Question

Hi there,

Please can anyone advise whether it is possible to decrypt a passworded SSIS dtsx package? We've inherited a package from someone else, but have never been provided with the password, so unable to save any amendments. We need to amend the ftp details so that the data moves to a different location.

Many thanks, Christina

Answer 1

0

If you have the package scheduled as a part of a SQL job you can pull the password from the job step execution. Just look for /DECRYPT in the string from the following SQL statement. This is the package password stored in plain text.

SELECT  sjs.command
FROM    msdb.dbo.sysjobs sj
        INNER JOIN  msdb.dbo.sysjobsteps sjs ON sj.job_id = sjs.job_id
WHERE   sj.name = <your job NAME>

answered Jul 31 '12 at 03:39 PM

SirSQL
4.6k ● 1 ● 3

Worked an absolute charm, thank you!

Aug 01 '12 at 06:44 AM csconstantinou

(comments are locked)

Decrypt DTSX file

Follow this question

Related Questions