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 you will be shown 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.

Contents

1. Introduction
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

	1 2 3 4 5 6