How to enable the Transform Data task fast load options (Enterprise Manager)

How to Install SQL Server 2000

How To

How to enable the Transform Data task fast load options (Enterprise Manager)

To enable the Transform Data Task fast load options

  1. After configuring the connections and transformations for a Transform Data task, click the Options tab.

  2. Select the Use fast load check box, and then select any of the other Microsoft® SQL Server™ fast load options that you want to use.

    The fast load options are only in effect when you use the Microsoft OLE DB Provider for SQL Server as the destination connection.

See Also

DTS Transformations

Tasks That Transform Data

Transform Data Task