DTS GUID ???? - SQL Server Forums

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

Import/Export (DTS) and Replication (2000)

DTS GUID ????

Author

Topic

rikleo2001
Posting Yak Master

185 Posts

Posted - 2008-03-11 : 12:06:33

Guys

I am working on a system with one job which runs a dts package liek this dtsrun /~Z233HJH23J2J3H2J3J2H32J3J23J23BJHB3H

As far as I know this could be Package name or GUID, but looks like it is encrypted one.. Now out of 50 DTS packages how would I know which one is this?

Any help?

Thanks in advance

SKR

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-11 : 12:36:24

Try like this:

select * from sysdtspackages

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-11 : 23:27:41

in msdb.

rikleo2001
Posting Yak Master

185 Posts

Posted - 2008-03-13 : 05:48:36

Guys, Thanks for that.. I tried that already. Here is what I have job DTSRun /~Z0xDCD4A74097CD642D2D8A8BB1045D0F7C0836D485E5E566DE3B8803FA29E32CFCCFA46E669CCF874B0C8DEF5FA48C035BFDD86AE6B6BA00337D9C171AD46499304BE0E480F5B75E0D5C385201ED5042A07B93F435919ABD03CBB768D21E6001B1C832B85D9067ACF0F507E5B994705738610FE5BCFAADEFAB4FB0EF

and under dtspackage all columns have the following ids
A3EE4858-22D5-4080-81C5-83420395DBFF

except Packagedata column..which is like that and none of them matches with above one.
0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000000000000010000000200000000000000001000000500000001000000FEFFFFFF0000000003000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

Any help?

Thanks

SKR

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-13 : 09:41:26

Did you try what i gave you? It will display names of packages as well as id's of jobs?

rikleo2001
Posting Yak Master

185 Posts

Posted - 2008-03-13 : 11:38:11

Yes I dis mate. I know what Id is.. but don't know which id is encrypted.Basically I need to descript that DTSRUN parameters.
I think I found an answer from the somewhere that you need to run dtsrundec utility to decrypt the parameters.
Thanks for your help

SKR

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-03-13 : 12:24:06

From SQL Server 2000 Books Online dtsrun Utility topic:
/!Y
Displays the encrypted command used to execute the DTS package without executing it.

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources