Update Batch Transform
The "Update Batch Transform" allows you to quickly update batches of data.
Please see the Azure Support page for more information before using this component with Azure databases.
• Batch Update Information
o Update Connection Manager - Select an existing connection manager or create a new one
o Table to update - Once the connection manager is set, you will select which table you wish to update.
o Command Timeout - the number of seconds that the command will wait before timing out during execution.
• Column Mappings - Here you will map the columns from the source to the columns in the selected destination table(Table to update). If the column names form the source are the same as the destination the mappings will occur automatically.
• Turn off internal transaction? - This option will turn off internal transaction, only use this for performance reasons.