Documentation forTask Factory

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


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.
Note:  The Task Factory Update Batch Transform requires an input source and and ADO.NET Connection Manager destination.


The following example displays using the Update Batch Transform in an existing package.

1. Create a new, or open the desired SSIS package.
2. Add a Data Flow task into your Control Flow, and then enter the Data Flow task workspace.Add Data Flow
3. Add a source input file into your Data Flow. In this example, we have configured a Flat File Source, with a Flat File Connection Manager that connects to a local flat file with values separated by the "," delimiter.
Flat File Source Editor configure columns

4. Add the Task Factory Update Batch Transform component to your Data Flow:

1. Select an existing Connection Manager, or configure a new Connection Manager for the destination connection.
ADO.Net Connection Manager
2. Select the table that the Update Batch Transform will upsert data into.
Task Factory Update Batch Transform select table

3. Match the input columns to the proper destination columns.
Task Factory Update Batch Transform column mappings
4. Set the key column. 


5. Select Ok to complete your configuration changes.
Task Factory Update Batch Transform select Ok

6. Map your Flat File Source to the Task Factory Update Batch Transform.Task Factory Update Batch Transform linked

7. Execute the Package.
Task Factory Update Batch Transform executed

Success: The Update Batch Transform successfully executed! The following is sample output from the selected table used in this example:

Table updated with the Task Factory Update Batch Transform