tDBBulkExec

Offers gains in performance while executing the Insert operations on a database.

This component works with a variety of databases depending on your selection.

The tDBOutputBulk and tDBBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database the selected database type. These two steps are fused together in the tDBOutputBulkExec component, detailed in a separate section. The advantage of using two separate steps is that the data can be transformed before it is loaded in the database.