Creating the Custom Task Framework
To include a user interface in a Data Transformation Services (DTS) custom task, you need to create the custom task framework. If you are displaying and updating a global variable through this user interface, add custom properties for the global variable name and value.
Creating the Framework
Create a custom task framework using the Active Template Library (ATL) custom task template, enabled for a user interface, provided with Microsoft® SQL Server™ 2000. Name the component DTSTskGVUpdate, the task class TaskGVUpdate, and the user interface GVUserIF. Change the Type field in ATL Object Wizard from TaskGVUpdate Class to Global Variable Update Task when creating the task class. For more information about using the templates with user interface support, see Building a Custom Task with User Interface from the ATL Custom Task Templates.
You can add an icon to the project resource file that will appear when the task is added to the Data Transformation Services (DTS) Designer design sheet. For more information about adding an icon to a custom task, see DTS Example: Adding Properties and Icons in Visual C++.
Adding Custom Properties
Add properties for the global variable name and value according to the following table.
| Property name | Type | Parameters | Description |
|---|---|---|---|
| GblVarName | BSTR | None | Name of the global variable to be displayed and updated. |
| GblVarValue | BSTR | None | Value of the global variable named by GblVarName. |
For more information about adding properties to an ATL custom task project, see Implementing and Testing a DTS Custom Task.