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 Icon	Transform Description
	The Update Batch Transform allows you to quickly update batches of data.

General

Task Factory Update Batch Transform General

Option	Description
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 Mappings	Here 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.

Task Factory Update Batch Transform

Update Batch Transform

General

Related Articles