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

Note:  The Task Factory Update Batch Transform requires an input source and and ADO.NET Connection Manager destination.

Example

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 Flow3. 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 select Connection Manager
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 Manager2. 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 mappings4. Set the key column. 

5. Select Ok to complete your configuration changes.Task Factory Update Batch Transform select Ok6. 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