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 |
|
shanilash
Starting Member
17 Posts |
 Posted - 2009-05-28 : 05:38:34
|
| Hi experts,is there any query to find out the DTS names used in a server.like (select * from sysjobs) for jobs |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-28 : 12:51:08
|
| are you using sql 2005? |
 |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2009-05-28 : 15:46:34
|
| SELECT DISTINCT name FROM msdb..sysdtspackages |
|
|
|
|
|
|
DTS package names