VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

DTS (Data Transformation Service) Search Tool

Carlos Alvarado  (2 Submissions)   Complete Applications   VB Script   Intermediate   Wed 3rd February 2021

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

Rate DTS (Data Transformation Service) Search Tool (7(7 Vote))

Download DTS (Data Transformation Service) Search Tool

DTS (Data Transformation Service) Search Tool Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters