Task Factory Update Batch Transform

 Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.

Note:  Please see the Azure page for more information before using this component with Azure databases.

Update Batch Transform

Transform IconTransform Description
Task Factory Update Batch Transform IconThe Update Batch Transform allows you to quickly update batches of data.


Task Factory Update Batch Transform General

Batch Update Information
  • Update Connection Manager - Select an existing connection manager or create  a new one.
  • Table to update - Once the connection manager is set, select the table you wish to update.
  • Command Timeout - The number of seconds that the command waits before timing out during execution.
Column MappingsHere you map the columns from the source to the columns in the selected destination table (Table to update). If the column names from the source are the same as the destination, the mappings occur automatically.
Turn off internal transaction?
This option turns off internal transaction.

Note:  Only use this for performance reasons.