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.
| Author |
Topic |
|
Peter.Bij@klm.com
Starting Member
12 Posts |
 Posted - 2003-05-16 : 06:00:05
|
| How can I find out which DTS packages is used by a certain job step. Now there is only a Hex-reference id like DTSRun /~Z0x352D6814167277B2B3A79A2A9348BFBCE5B4E80D01A325965EED5F5DA42F9E276252A3845CC81921E5FDF6E6310F92F368F4CBAC18205A7ACC46B05666F982D215CA8E283452715B23A1127AC78E1CCE7EE32796B7017FBAD0F74F687BB4795DF06A3B But I can not find the package that is used by this command. The only relation is the description, but allas, the Administrator before me was so administrative and didn't fill in the name or description properly Can anyone help me Thanks in advance |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-16 : 06:20:33
|
| Hi!Please don't cross post next time.The DTS parameters are encrypted.However, you can find out which package is run by using SQL profiler and running a trace. Start the job while the trace is running. After a few moments, a command looking like this will be run:exec msdb..sp_get_dtspackage N'somepackagename', null, nullYou can see the package name there. |
 |
|
|
Peter.Bij@klm.com
Starting Member
12 Posts |
Posted - 2003-05-16 : 09:08:19
|
| Sorry Andraaxwe tested this methode but it did not help us to find out the used DTS for a specific job.Ofcourse this was a testjob so we know what package we are using, but for some other jobs we still don't know.So anyone else with another suggestion |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-16 : 10:49:21
|
| Hi Peter.Where are your packages saved? If they are saved in the SQL Server then the above method should have worked, so I guess they are saved as files, or in Meta Data Services. If it's in MetaData, look for this statement using profiler:set dateformat mdy Insert into #RTblObjColTemp (IntID) SELECT tp.IntID from RTblNamedObj tn, RTblDTSProps tp WHERE tn.IntID = tp.IntID AND tn.Name = 'somepackagename'If it's in files, I honestly don't know how to find it. I don't think the encrypted parameters are easy to decrypt. |
|
|
|
|
|
|
|
|
DTS packages and Job refenrence