TechTarget - The IT Media ROI Experts
[image]
[image] [image]
[image]
[image]
[image]
[image]
[image] Home > Ask the SQL Server Experts > Joe Toscano - Integration Services/Development Questions & Answers > Query to search text in old DTS packages in SQL Server?
[image]
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Query to search text in old DTS packages in SQL Server?

Joe Toscano EXPERT RESPONSE FROM: Joe Toscano
[image] Pose a Question
[image] Other SQL Server Categories
[image] Meet all SQL Server Experts
[image] Become an Expert for this site

[image]
[image] Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 05 December 2007
We have just migrated to SQL Server 2005. We need to find all the old DTS packages that reference a specific table. Is there a query that will allow me search the text of all my old DTS packages?

>
EXPERT RESPONSE
This is something I looked into with a recent client. We were able easily see what database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, but not DTS packages.
[image] Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


[image] [image] [image] RELATED CONTENT
[image] Joe Toscano - Integration Services/Development
[image] How to convert DTS packages to SSIS and overwrite data
[image] How to migrate DTS to SSIS and deploy SSIS packages
[image] Error importing Excel data to SSIS in SQL Server 2005
[image] Delete .bak files automatically with CLR
[image] DTS package designed to overwrite extract.xls
[image] Displaying a SQL Server database report in Excel
[image] Call triggers in a stored procedure
[image] Stored procedure practices in SQL Server
[image] SQL Server permission to create jobs and schedules in SSIS
[image] Problems with structured exception handling
[image] SQL Server data warehousing/business intelligence
[image] Tips for tuning SQL Server 2005 to improve reporting performance
[image] Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
[image] Troubleshoot Web service issues in SQL Server 2005 Reporting Services
[image] Ordering the results of a SQL query
[image] SSIS error message due to installation problem on SQL Server 2005
[image] Configuring SQL Server with a changed computer name
[image] Using MDX and UDM in a SQL Server Analysis Services environment
[image] Change data capture in SQL Server 2008 improves BI reporting accuracy
[image] Manage traces in SQL Server 2005 Analysis Services with XMLA commands
[image] Tutorial: SQL Server 2005 Analysis Services
[image] SQL Server upgrades and patches
[image] SQL Server consolidation: Why it's an optimization technique
[image] Should you upgrade to SQL Server 2005 or SQL Server 2008?
[image] Monitor database mirroring and replication after a SQL Server upgrade
[image] Upgrade live applications to SQL Server 2005 for high availability
[image] SQL Server high availability when upgrading to SQL Server 2005
[image] How to restore SQL Server database to transition server during upgrade
[image] Top 10 SQL Server Integration Services (SSIS) and DTS tips
[image] Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003
[image] FAQ: SQL Server databases how-to
[image] Upgrading to SQL Server 2008 advantages and hardware requirements
[image] [image] [image] RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
[image] data aggregation  (SearchSQLServer.com)
[image] data preprocessing  (SearchSQLServer.com)
[image] data warehouse  (SearchSQLServer.com)
[image] FileMaker  (SearchSQLServer.com)
[image] GIS  (SearchSQLServer.com)
[image] MOLAP  (SearchSQLServer.com)
[image] pivot table  (SearchSQLServer.com)
[image] Quiz: SQL Server 2000  (SearchSQLServer.com)
[image] SQL  (SearchSQLServer.com)
[image] T-SQL  (SearchSQLServer.com)
[image] [image] [image] RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


[image]
[image]
[image] Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts. [image]
Browse our Expert Advice
Operating Systems IT Management Networking Database
Security Servers and Storage Applications and Development Career Center
[image]


[image]
Home News Topics ITKnowledge Exchange Tips Ask the Experts Multimedia White Papers IT Downloads
[image] About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
[image]
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map

All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy  

You are viewing a mobilized version of this site...
View original page here

Mobilized by Mowser Mowser