Task Factory Update Batch Transform

Last Modified on 28 September 2020

 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.

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.

Related Articles

  • None
Was this article helpful?
Thank you for your feedback! It has been submitted to the SentryOne Docs team.
User Icon

Thank you for your feedback. It has been submitted to the documentation team.

Copyright © SQL Sentry, LLC. All rights reserved.