Task Factory Delete 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.

Additional Information: Please see the Azure Support page for more information before using this component with Azure databases.

Delete Batch Transform

Transform IconTransform Description
Task Factory Delete Batch Transform IconThe Delete Batch Transform allows you to quickly delete batches of data.

General Tab

Task Factory Delete Batch Transform General

Delete Batch Information

Delete Connection ManagerSelect an existing connection manager if available, or create a new one.
Table to delete rows fromChoose the table where you want to delete rows.
Command TimeoutSet the number of seconds before the command times out.

Select Keys to be used to delete rows in the selected table

Map the columns from the source to the columns in the destination to be used to delete the rows in the selected table.

Turn off internal transaction? 

Only use this option for performance reasons. It has the potential to send some data and not others if there is an error.