Guru's Guide to SQL Server Architecture and Internals, The

Custom Tasks

As I mentioned earlier, DTS is based on an extensible COM model. One of the benefits of this is that you can create your own custom tasks as COM objects and install them into the DTS Designer. There are a couple of ways to go about this: You can create a custom task object from scratch in a language capable of implementing COM interfaces, or you can customize one of the sample custom task components included with SQL Server. Depending on your needs, either of these approaches can be a viable method of extending DTS, so I'll show you how to do it both ways.

Creating a New Custom Task

All DTS task objects implement the DTS CustomTask interface. Any custom task that you build will also need to implement this interface. In terms of interface ...