Developer activities

Bulk Insert

link

Designer panel​

• Configure Connection... - Select an existing database connection or add a new one using the Connection Wizard.
• Target table name - The destination database table name. This field supports only String variables.
• Input data table - The source DataTable for the items to be inserted. This field supports only DataTable variables.

Properties panel​

Common​

• Continue on error - This field only supports Boolean values (True, False). The default value in this field is False. As a result, if this field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
• DisplayName - The display name of the activity. This field supports only String variables.
• Timeout - Specifies the amount of time (in milliseconds) to wait for the SQL command to run before an error is thrown. The default value is 30000 milliseconds (30 seconds) and must be greater than or equal to 0. If you set this property to 0 or leave it empty, the database provider's default timeout is used. This field supports only Int32 variables.

Connection Configuration​

• Connection string - The connection string used to establish a database connection. This field supports only String variables.
• Existing connection - An already open database connection. If such a connection is provided, the ConnectionString and SecureConnectionString properties are ignored. This field supports only DatabaseConnection variables.
• Provider name - The name of the database provider used to access the database. This field supports only String variables.
• Secure connection string - The connection string used to establish a database connection as Secure String. This field supports only SecureString variables.

Input​

• Input data table - The source DataTable for the items to be inserted. This field supports only DataTable variables.
• Target table name - The destination database table name. This field supports only String variables.

Misc​

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output​

• Affected rows count - Stores the number of affected rows into an Int64 variable.

• Existing connection - An already opened database connection obtained from the Connect to Database activity.
• Input data table - The DataTable variable that is inserted into the Table. The DataTable columns' name and description must match the ones from the database table.
• Target table name - The target database table in which the data is to be inserted.

Advanced options​

Other​

• Continue On Error - Specifies if the automation should continue even when the activity throws an error.
• Timeout - Specifies the amount of time (in milliseconds) to wait for the SQL command to run before an error is thrown. The default value is 30000 milliseconds (30 seconds) and must be greater than or equal to 0. If you set this property to 0 or leave it empty, the database provider's default timeout is used.

Output​

• Affected rows count - The number of affected rows stored in an Int64 variable.