Export (0) Print
Expand All
Expand Minimize

How to add a multiphase data pump transformation function using an ActiveX script (Enterprise Manager)

SQL Server 2000

How to add a multiphase data pump transformation function using an ActiveX script (Enterprise Manager)

  New Information - SQL Server 2000 SP3.

To add a multiphase data pump transformation function using an ActiveX script

  1. After activating the multiphase data pump feature and configuring your source and destination connections, click the Transformations tab.

  2. In the Phases filter list, click the data pump phase you want to add.

The Phases filter list displays all the transformations configured for a specific data pump phase. By default, the Row transform phase is selected.

  1. 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, click Delete, and then click New.
  2. In the Create New Transformation dialog box, click ActiveX Script.

  3. Click the Source Columns tab, and then use the arrow buttons to select columns for the transformation.

  4. Click the Destination Columns tab, and then use the arrow buttons to include a column in the transformation.

  5. Click the General tab, click Properties, and then click the Phases tab.

  6. Select the data pump phases for which you will be adding Microsoft® ActiveX® script functions, and then for the selected phases, type the names of those functions in their respective boxes.

  7. In the ActiveX Script text box, enter the ActiveX script code for each function.

    The function names specified in the ActiveX Script text box must match those entered on the Phases tab.

    Security Note  Scripts can be the source of security vulnerabilities; they can invoke system functions without user knowledge or intervention and may contain security credentials in plain text. Review the script for security issues before use. For more information, see Security and Scripting.

See Also

ActiveX Script Transformation

Multiphase Data Pump Functionality

Tasks That Transform Data

Show:
© 2014 Microsoft