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 - 2005-06-17 : 08:03:08
|
| Steve writes "Simple question.I need to completly change the structure of an existing table in my database. Therefore I need to search for everywhere the table is refernced. I can search views & stored procedures fine. But how can I search all my Local Packages for a reference?I notice the msdb.sysdtspackages table holds some binary data that may hold the key, but can not read that either.Any help would be apprecited.Many Thanks,Steve" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-17 : 08:04:41
|
| I'm not a DTS expert, but I think the only way to search a DTS package is to save it as a Visual Basic file, then search the code in that file. You may want to try this web site, they may have a better solution:http://www.sqldts.com/ |
 |
|
|
|
|
|
DTS in SQL Server 2000