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 |
|
SHardy
Starting Member
35 Posts |
 Posted - 2007-04-18 : 12:04:22
|
| Hi,I need to find out if a particular table is used in any other DTS SQL tasks, other than the one that I am aware of.Reason... I want to remove any un-required data from the table as it is HUGE and is having quite an impact. But I need to make sure that I am not going to remove data that is used elsewhere.There is no "search" function available in DTS. Is there a fairly simple way that I can (maybe programatically) search through all DTS packages for the object name as a string? Other than manually trawling through the many, many packages?Any help would be GREATLY appreciated.Thanks,Simon |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-18 : 12:11:04
|
| I am not sure whether this is possible from within SQL Server.There are some third party tools available which facilitates this. Feel free to google on "DTS Package Search".Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Search all DTS packages for string