Find the SSIS and DTS packages that reference a server. SSIS-DTS Package Search provides an easy way to find the SSIS and DTS packages that reference a server, database, table, stored procedure, column, etc. Be proactive and easily find the changes required in the SSIS and DTS packages before your next database roll out.

SSIS-DTS Package Search Features:
1. searches all connections, properties, steps, SQL, scripts and tasks within all packages in a package repository.
2. searches packages stored on Microsoft SQL Server 7.0/2000/2005/2008 with any service pack level or in .dts files.
3. matches on property name in the search with the Property Name option turned on.
4. searches are case senstive/insensitive with the Case Sensitive option.
5. multiple search terms can be found in a package.
6. AND/OR the search terms with the Match Any Search String/Match All Search Strings.
7. search for the terms anywhere in the package or limit to the property level with Match Level.
8. search for the terms in a specific property.
9. DTSRUN SQL agent job step search with optional decryption
10. great for security audits (the screen shot above shows the advanced search configuration to find all the packages with connections the use the sa or admin user id.
11. filter the "chatty" results of a single term search.
12. no need for those complicated regular expressionssearch results are presented in a tree view.
13. search results can be saved for viewing at a later time.
14. generate complete package documentation by switching to documentation mode
15. enable/disable search warnings, added specifically to handle packages with UDL connections
16. select file based packages at the directory level
17. 1 year of support included.

Requirements:
1. a PC with a 300mhz processor and 256MB of RAM, a 1ghz processor and 512MB of RAM is recommended.
2. any edition of windows that supports Microsoft .Net Framework v2.0 32 bit editions only.
3. Microsoft .Net Framework v2.0.
4. SQL Server 2000 client tools with SP4 applied OR
5. SQL Server 2005 client tools with the Microsoft SQL Server 2005 Backward Compatibility Components installed.
6. SQL Server 2008 client tools with the Microsoft SQL Server 2008 Backward Compatibility Components installed.

The license of this software is Free Trial Software, the price is $299.00, you can free download and get a free trial.