DTS

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

ccc24 Mr or Mrs. 500 Points: 503 More actions · Answer 1

Mr or Mrs. 500

Points: 503

July 26, 2004 at 5:22 am

Sorry, you're SOL.

Pat Mong

JDigital007 SSC Enthusiast Points: 191 More actions · Answer 2

Yes, if he you have access to the master table there is a dts_ table that contains the password in plain text. Great security!

davidvairin Old Hand Points: 345 More actions · Answer 3

Which master table is it? I don't see one directly related to dts.

wade ungaro SSC Veteran Points: 290 More actions · Answer 4

Do you know the exact table? I'm having the same problem. I can't find any tables in model or msdb that would contain this information. Thanks.

out,

swaders

philcart SSC-Forever Points: 47796 More actions · Answer 5

Don't know which version of SQL you're seeing this in.

DTS Packages are stored as a Binary object in the sysdtspackages table which resides in msdb.

I don't know any method for recovering a lost password from the DTS package.

--------------------
Colt 45 - the original point and click interface

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 6

I'm going to go out on a limb here and guess you didn't help him too much Phil.

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.