DBBulkCopy allows to efficiently copy large amounts of rows to a table in a SQL Server or Oracle database.
The type of database driver to use to connect to the database. The supported driver types are SQL Server and Oracle.
The connection string that specifies how to connect to the database.
The timeout value in seconds. 0 indicates the bulk copy operation will wait indefinitely.
The name of the destination table.
The number of rows to collect in a transaction before it is committed to the server.
Suppose you have a CSV text file with many records that need to be loaded into a database table. Using the DbBulkCopy function as shown below will run much quicker than doing it using the more generic ExecuteSQL function.
Set the ‘Target’ property of the SetValue function to ‘DbBulkCopy.Loader.Write’. Then click the editor button ‘…’ next to the ‘Source’ property to open the Set Fields editor to assign the values to the table’s columns.