SQL Server DTS

Chapter 16. Creating Your Own Custom Task

It probably wouldn’t surprise you if you were told that DTS is written with Microsoft’s Component Object Model (COM) technology. Because of COM, many of the features inside DTS can be extended using any programming environment that supports COM. In fact, some of the “built-in” features of DTS are mere extensions of a base COM object, which certainly is true for tasks. All the DTS tasks that were introduced in Chapter 4, “DTS Tasks,” and Chapter 5, “More DTS Tasks,” are COM objects that implement interfaces defined in the base DTS task object. As such, they really are just another regular custom task, which ...