Home arrow ASP arrow Creating DTS Packages With SQL Server 2000

Creating DTS Packages With SQL Server 2000

Data Transformation Services (DTS) were added to SQL Server 7 and allow us to combine several data-related tasks into one common object. In this article Tim shows us how to create a DTS package with SQL Server 2000 that will access a database and email the results of a query to some sales executives. He also shows us how to execute and error trap DTS packages from within an ASP script.

Author Info:
By: Tim Pabst
Rating: 5 stars5 stars5 stars5 stars5 stars / 327
February 01, 2002
  1. · Creating DTS Packages With SQL Server 2000
  2. · What is a DTS package?
  3. · Creating a DTS package
  4. · Exporting the results set to a text file
  5. · Executing our DTS package in ASP
  6. · Conclusion

print this article

Creating DTS Packages With SQL Server 2000
(Page 1 of 6 )

Back in the days when Microsoft SQL Server 6.5 was still hot property, the bulk copy program was the only way to backup or export databases from SQL Server to other data sources, such as other database servers or text files. DBA's (Database Administrators) would spend hours setting up and automating backup scripts for each server, and it wasn't until the release of SQL Server 7 that Microsoft finally gave DBA's a set of drag and drop tools to accomplish this more quickly and easily. This set of tools is known as DTS (Data Transformation Services).

By creating DTS packages, we can combine several tasks into one process and use any programming language that supports automation (such as Visual Basic 6, ASP, or C++) to execute these packages and monitor their progress for errors, etc.

In this article I'm going to show you how to create a DTS package that retrieves sales data from a Microsoft SQL Server 2000 database and emails it to a fictitious list of company executives. We will take an in-depth look at creating the package, what tools we can use to make our job easier, and the details of the DTS.Package COM object, which we can use to execute a DTS package. We will also look at calling a DTS package from ASP.

To test the examples in this article, you should have access to a Windows 2000 web server running IIS version 5 (configured with an SMTP mail server), as well as SQL Server 2000. You should also be familiar with VBScript, ASP, and some basic SQL "INNER JOIN" syntax.
blog comments powered by Disqus

- Central Scoreboard with Flash and ASP
- Calorie Counter Using WAP and ASP
- Creating PGP-Encrypted E-Mails Using ASP
- Be My Guest in ASP
- Session Replacement in ASP
- Securing ASP Data Access Credentials Using t...
- The Not So Ordinary Address Book
- Adding and Displaying Data Easily via ASP an...
- Sending Email From a Form in ASP
- Adding Member Services in ASP
- Removing Unconfirmed Members
- Trapping HTTP 500.100 - Internal Server Error
- So Many Rows, So Little Time! - Case Study
- XDO: An XML Engine Class for Classic ASP
- Credit Card Fraud Prevention Using ASP and C...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials