Description: 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.
To Search:
File list (Check if you may need any files):
@PSC_ReadMe_55908_1.txt
DtsSearch
.........\dtsSearch.vbp
.........\frmDetalhe.frm
.........\frmDetalhe.frx
.........\frmDTS.frm
.........\mssccprj.scc
.........\vssver.scc
Download