How to call a COM object that customizes one or more data pump phases (Enterprise Manager)
To call a COM object that customizes one or more data pump phases
- After activating the multiphase data pump feature and after configuring your source and destination connections, click the Transformations tab.
- In the Phases filter list, click the data pump phase you want to customize.
The Phases filter list displays all the transformations configured for a specific data pump phase. By default, the Row transform phase is selected.
- Do one of the following:
- If the columns you want are not already mapped to another transformation, click New.
- If the columns you want are already mapped, click on the mapping line for the transformation and click Delete, and then click New.
- If the columns you want are not already mapped to another transformation, click New.
- In the Create New Transformation dialog box, click the entry corresponding to the custom transformation (COM object) that will be called.
Note If the COM object has been installed on your computer but does not appear in the Create New Transform dialog box, and you have enabled Data Transformation Services (DTS) caching, you must refresh the cache. In SQL Server Enterprise Manager, right-click Data Transformation Services, and then click Properties. Under Cache, click Refresh Cache.
- Click the Source Columns tab, and then use the arrow buttons to select columns for the transformation.
- Click the Destination Columns tab, and then use the arrow buttons to include a column in the transformation.
- Click the Phases tab, and then click the data pump phases that will call the custom transformation you are supplying.
Note If the custom transformation includes a user interface, you can click the General tab and then click Properties to enter any additional information for the transformation.