login about faq

Hi everybody!

I've got a problem with SQL SERVER 2000: how can i get an inventory of all DTS that use a certain object?

Thanks!

asked Jan 08 at 14:03

jesus's gravatar image

jesus
1


My solution to this was to export the DTS packages as BASIC scripts and search in the text that is generated. I also used this to copy code from one DTS package to another and to double check, compare and contrast, the internal scripts.
The BASIC export is in plain text, just not pretty, so it is easily searched with any text utility.

answered Jan 08 at 17:20

dvroman's gravatar image

dvroman
1862

Your answer
toggle preview

Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Ask SQL Server Central is a community service provided by Red Gate.
Powered By OSQA