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 |
|
ells
Starting Member
25 Posts |
 Posted - 2008-01-15 : 07:17:07
|
| all of the SQL Server Agent jobs the steps are specified as DTSRun /~Z0x8999CD27E9E610920064F.............The number Z0x8999CD27E9E... does not seem to reference any of the DTS I can see and the length of the references is longer than the package ID.How do I translate this to find out which DTS this referes to.Many Tanks.Mark. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-15 : 10:47:03
|
| from command prompt:DTSRun /~Z0x8999CD27E9E610920064F /!X /!Cwill copy it to the clipboard. then paste into notepad to seecan type in dtsrun /? to see all switches |
 |
|
|
|
|
|
how to work out which dts is run by an Agent job