Delete Batch

Delete Batch

Parent Previous Next

Delete Batch Transform

The "Delete Batch Transform" allows you to quickly delete batches of data.

Azure Users

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

  Delete Batch Information

o   Delete Connection Manager  - Select an existing connection manager if available, or create a new one

o   Table to delete rows from - Choose the table in which you want to delete rows from

o   Command Timeout - Set the number of seconds before the command will timeout

  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

Advanced Tab

  Turn off internal transaction? - Only use this option for performance reason. It has the potential to send some data and not others if there is an error.