DTS password problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » DTS password problem

11 posts, Page 1 of 2

1 2 »»

DTS password problem

Rate Topic

Display Mode

Topic Options

Author

Message

ntt123

Posted Monday, November 12, 2007 6:44 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:18 AM
Points: 14, Visits: 616

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

Post #421023

russell-154600

Posted Monday, November 12, 2007 7:29 AM

Valued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:13 AM
Points: 69, Visits: 183

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.

Post #421043

ntt123

Posted Monday, November 12, 2007 8:54 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:18 AM
Points: 14, Visits: 616

Thanks

Post #421094

K. Brian Kelley

Posted Wednesday, November 14, 2007 5:05 PM

Keeper of the Duck

Group: Moderators
Last Login: Wednesday, May 08, 2013 5:14 AM
Points: 6,583, Visits: 1,787

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

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog |

LinkedIn | Twitter

Post #422377

ntt123

Posted Thursday, November 15, 2007 7:49 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:18 AM
Points: 14, Visits: 616

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

Post #422639

ganeshtt

Posted Friday, November 30, 2007 7:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 04, 2007 2:16 AM
Points: 2, Visits: 10

Hi,

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

Post #428087

ntt123

Posted Friday, November 30, 2007 9:03 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:18 AM
Points: 14, Visits: 616

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

Post #428165

ganeshtt

Posted Monday, December 03, 2007 7:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 04, 2007 2:16 AM
Points: 2, Visits: 10

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. :)

Post #429083