DTS Custom Task

DTS Programming

DTS Programming

DTS Custom Task

This Microsoft® Visual C++® sample creates and registers a Data Transformation Services (DTS) custom task that is similar to the CreateProcessTask object.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\CustomTasks\DTStask

Running the Sample
  1. In the Visual C++ development environment, open and run Dtstask.dsw.

  2. On the Build menu, click Build dtstask.dll to build the project.

  3. In Microsoft SQL Server™ Enterprise Manager, right-click Data Transformation Services, click Properties, and then click Refresh Cache, if caching is active.

  4. Include the custom task in a DTS package.

See Also

Implementing and Testing a DTS Custom Task

DTS Programming Samples