The following code does not handle transactions or errors, so it can be simple and understandable.
It is better to add transactions and error handlers in the real environments.
→ Here is what the DTS package would look like:
For your convenience, this next section is available in a clickable Microsoft Word document. Click here to view or download the DTS steps and SQL script.
Requires Membership to View
To gain access to this and all member only content, please provide the following information:
By submitting your registration information to SearchSQLServer.com you agree to receive email communications from the TechTarget network of sites, and/or third party content providers that have relationships with TechTarget, based on your topic interests and activity, including updates on new content, event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile, unsubscribing via email or by contacting us here
- Your use of SearchSQLServer.com is governed by our Terms of Use
- We designed our Privacy Policy to provide you with important disclosures about how we collect and use your registration and other information. We encourage you to read the Privacy Policy, and to use it to help make informed decisions.
- If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States.
Dig Deeper
Introduction Step 1: Tracing statements in SQL Server 2000 Step 2: Tracing statements in SQL Server 2005 Step 3: How to use SQL Trace definition Step 4: Script example for SQL Trace Step 5: SQL Trace results in SQL Profiler |
| ABOUT THE AUTHOR: |
|
Michelle Gutzait works as a senior databases consultant for ITERGY International Inc., an IT consulting firm specializing in the design, implementation, security and support of Microsoft products in the enterprise. Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant. For the last 10 years, she has worked exclusively with SQL Server. Her skills include database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS packages, administrative and infrastructure tools development, reporting services and more. Copyright 2007 TechTarget |
More on SearchSQLServer.com
This was first published in March 2007