rarascon (11/21/2013)
Right, this is more along the lines of what I'm trying to do - I want to know if ANYTHING is using those tables before I disable the package.
I'm not sure that a text search will always give you that security. If any of your packages invokes stored procs or views, perhaps those objects reference the tables you are interested in.
So I would suggest doing a search in T-SQL, perhaps using SQL Search (which is free and works well), to look for references to those tables in other DB objects.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.