One of my buddies wrote a program that can help you find the DTS packages that reference a server, database, table, stored procedure, column, etc. I’ve worked with DTS enough times to know that this is really a very handy tool to help your day-to-day job and DTS package promotion from one environment to another. He has sold the program worldwide and it really performs well.

Check it out here at Gerasus Software.