October 2003
Intermediate to advanced
1072 pages
24h 21m
English
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.
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 ...
Read now
Unlock full access