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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-11 : 07:46:29
|
| Les writes "Can you tell me how to out the name of a DTS package that is called as part of a scheduled SQLagent job? I can see the reference to it in the sysjobsteps table, but this just gives a very long hex string starting with something like DTS~Z0xBF.At the moment it is very hard to workout what DTS packages are bing called in a scheduled jobsTHanks Les" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-02-11 : 08:21:08
|
| Do a better job of documentation ...As best I can tell, then only thing you can do is work backwards and use trial and error. Schedule a dts package. Look at the job and compare the encrypted DTSRun call to what is in your job. Same? That's the package. Not the same? Try another one ...Maybe there is a better way, I dunno.Jay White{0} |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-11 : 10:22:41
|
| You can also use /!Y to get the encrypted command to compare.If you are happy for the text to be viewable then schedule the dtsrun manually giving the name of the package rather than encrypted text.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
DTS packages information