x

Decrypt DTSX file

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
more ▼

asked Jul 31, 2012 at 02:27 PM in Default

csconstantinou gravatar image

csconstantinou
20 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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>
more ▼

answered Jul 31, 2012 at 03:39 PM

SirSQL gravatar image

SirSQL
4.8k 1 3

Worked an absolute charm, thank you!
Aug 01, 2012 at 06:44 AM csconstantinou
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1840

asked: Jul 31, 2012 at 02:27 PM

Seen: 588 times

Last Updated: Aug 01, 2012 at 10:08 AM