SSIS-DTS Package Search

Home

Download

Purchase

Blog

News

Free

About

SSIS-DTS Package Search 2.0

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.

Screen Shots

What's NEW in SSIS-DTS Package Search 2.0

searches or documents Sql Server 2005 and 2008 Integration Services packages
Expression Summary, a list of all expression in the package with the object and property being set.
an expression that sets a property is shown at the property detail level.
can search any combination of package sources in one execution, files, directories, SQL Server and Integration Services.

Features:

searches all connections, properties, steps, SQL, scripts and tasks within all packages in a package repository.
searches packages stored on Microsoft® SQL Server 7.0/2000/2005/2008 with any service pack level or in .dts files.
matches on property name in the search with the Property Name option turned on.
searches are case senstive/insensitive with the Case Sensitive option.
multiple search terms can be found in a package.
AND/OR the search terms with the Match Any Search String/Match All Search Strings.
search for the terms anywhere in the package or limit to the property level with Match Level.
search for the terms in a specific property.
DTSRUN SQL agent job step search with optional decryption
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.
filter the "chatty" results of a single term search.
no need for those complicated regular expressionssearch results are presented in a tree view.
search results can be saved for viewing at a later time.
generate complete package documentation by switching to documentation mode
enable/disable search warnings, added specifically to handle packages with UDL connections
select file based packages at the directory level
1 year of support included.
follow this link to download a fully working copy of SSIS-DTS Package Search with a 30 day evaluation license.

Price:

$299 US
follow this link to purchase a copy of SSIS-DTS Package Search.

System Requirements:

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