DTS password problem

Question

DTS password problem

ntt123

SSC-Addicted

Points: 400
More actions
November 12, 2007 at 6:44 am

#119464

Hi, everyone
We have a problem with one of our DTS package.
It was created some years ago, and it developer had left company even before I came.
The package has password and nobody remembers it including that developer(we contacted him).
if anybody has an idea how wee can open this package please help!
Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

russell-154600 Ten Centuries Points: 1375 More actions · Answer 1

don't think it can be done (short of editing a backup of msdb with a hex editor). may try opening ticket with MS PSS team.

ntt123 SSC-Addicted Points: 400 More actions · Answer 2

ntt123

SSC-Addicted

Points: 400

November 12, 2007 at 8:54 am

#750284

Thanks

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Is anything still executing the DTS package, such as a SQL Server Agent job?

K. Brian Kelley
@kbriankelley

ntt123 SSC-Addicted Points: 400 More actions · Answer 4

Hello, everyone

Checking internet I combine everything and found my own solution

It takes 5 minutes and do not need any script to compile

1. transfer package ownership to my domain account

2. transfer job to my account

3. execute dtsrun DTSRun /~Z0x5...... with switches /!X /!C from my machine

It gave you decrypted line with parameter /M "password"

When I was trying to do this on server it did not give /M parameter, only from my machine

Thanks to everybody for help

ganeshtt SSC Enthusiast Points: 136 More actions · Answer 5

Hi,

I am facing the same problem, can you explain me all the steps in sequence you have done to resolve the issue

ntt123 SSC-Addicted Points: 400 More actions · Answer 6

Hi, you need to have admin account to do all of this

I did following steps

1. transfer package ownership to my domain account

use this stored procedure

sp_reassign_dtspackageowner

[@name =] 'name',

[@id =] 'id',

[@newloginname =] 'newloginname'

You can find package id from sysdtspackages table

'newloginname' = your domain account

2. transfer job owner for this dts package to my domain account

3.

execute dtsrun DTSRun /~Z0x5...... with switches /!X /!C

from my machine

Z0x5...... is encrypted line from job step

for this purpose create batch file with lines

DTSRun /~Z0x5B4B.......2D495E /!X /!C

pause

DTSRun /~Z0x5B4B.......2D495E is a full line from the job step

I added pause at the end to read what it tells you

You should see lines

Dtsrun: LOading

dtsrun: Executing

After that you can paste to any notepad

It looks like this

DTSRun /S "ServerName" /N "DtsPackName" /M "password" /E /!X /!C

It gave you decrypted line with parameter /M "password"

Let me know when you done

ganeshtt SSC Enthusiast Points: 136 More actions · Answer 7

Hi,

Thanks a lot for the details explanation. I have tried your solution and it works. Once again thanks for you prompt reply and the good solution. 🙂

tutumho SSC Journeyman Points: 75 More actions · Answer 8

tutumho

SSC Journeyman

Points: 75

July 13, 2008 at 9:07 am

#842096

Thanks for great help....

hrudhay-385221 SSC Veteran Points: 217 More actions · Answer 9

hrudhay-385221

SSC Veteran

Points: 217

September 22, 2010 at 1:20 am

#1225354

I could't stop to say Thank you for gr8 tip.

gagsji Valued Member Points: 67 More actions · Answer 10

assuming I am running the batch job from my (client) machine do I have to provide all the switches and the information like /S /U /P /N.

I would appreciate if you can please post the exact syntax.