How to configure the fast load batch options (Enterprise Manager)
To configure the fast load batch options
- After configuring the connections and transformations for a Transform Data task, click the Options tab.
- Select the Use fast load check box.
The fast load options are only in effect when you use the Microsoft® OLE DB Provider for SQL Server as the destination connection.
- In Insert batch size box, enter a value for the batch size.
- Optionally, select the Commit final batch check box if you want to commit all rows in the last batch that will be copied prior to an error.
- In the Max error count box, enter a value to specify the number of row-level errors detected by the Transform Data task plus the number of batch failures that must be exceeded before data pump operation for the task is terminated.