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 |
|
kelleyb
Yak Posting Veteran
61 Posts |
 Posted - 2007-04-23 : 18:46:27
|
| I've inherited a monster. Is there a way to query system tables for unused packages, or DTS packages that are not referenced anywhere else? You don't have to write my code for me, but a helpful pointer to the tables I should be looking at would be helpful.Thanks folks."Pray, 'prA, from Latin precari, from prec-, prex; verb:. To ask that the laws of the universe be annulled in behalf of a single petitioner confessedly unworthy." - Ambrose Bierce (1842-1914) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 23:46:41
|
| Don't think so, people may go to em and run the package manually. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-04-24 : 09:12:53
|
| Amend all packages to put a "I have started" step into the beginning. Review the log after a period of time, and all not-logged are candidates for deletion/renaming. |
|
|
|
kelleyb
Yak Posting Veteran
61 Posts |
Posted - 2007-04-24 : 14:56:33
|
| Yeah... given how many different ways a package can be run, and the fact that they can contain any number of non-SQL related tasks, it'll be hard to just start deleting packages. I'm gonna opt for the logging process and just start weeding them out over time.Many thanks Murphy and Miao"Pray, 'prA, from Latin precari, from prec-, prex; verb:. To ask that the laws of the universe be annulled in behalf of a single petitioner confessedly unworthy." - Ambrose Bierce (1842-1914) |
|
|
|
|
|
|
|
|
Find unused DTS packages