Task Factory Update Batch Transform

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.

General 

Task Factory Update Batch Transform General

OptionDescription
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.