by Carlos Alvarado (2 Submissions)
Category: Complete Applications
Compatability: VB Script
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(7 Votes)
Search strings in DTS (Data Transformation Services) in SQL SErver. Microsoft don't provide such tool. Allows, for instance, find what task/package contains certain table or field. Accepts a table name, field name or any text and returns the packages/tasks where the text is. This code is usefull when you have lots of DTS packages that perform changes on tables that exist in the various database. Where is that table ??? Find with this tool. Uses SQlDMO.
Assumes
SQL Server acess is needed
Download DTS (Data Transformation Service) Search Tool (7 KB)
VBcoders