Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 deciphering a sp

Author  Topic 

jdavidson
Starting Member

5 Posts

Posted - 2006-01-23 : 14:56:33
Good afternoon all!! I am trying to decipher a sp left behind by a predecessor and it is calling a DTS package (as seen below). Is there any way to determine which dts package this is referencing?? Thanks for any help you can provide. I have never seen a package called this way from a stored proc...generally if using the xp_cmdshell there is a reference to the server name and the package name. I'm at a loss...

EXEC master..xp_cmdshell 'DTSRun /~Z0xCBD39FE58D59F375B7847426706C4542438EC1AB88236A5E53BC6587A82D95886A7E509CD7727ED887D59CA5721673B79981F7040493D6F0844A777BAA436C8AD1443EDAA2664E51E51F756B73F9B9867F6379DF8C48376B0A7C6D38CC8CBCEAC5483D9D5ECEEF0F4AB279470A45DB3C90CF2177A4D98928B143B16DF7F2F290E36D593A7CABC214120E7DB836B9726817F39539B8CD1F70003504 ', NO_OUTPUT

Thanks again for taking a peek at this.

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2006-01-23 : 16:01:00
It looks like to me that it is encrypted using DTSRunUI..There might be a tool available to decipher it..

Go to Top of Page
   

- Advertisement -