Activities
latest
false
- Overview
- Cryptography
- Database
- Java
- Python
- WebAPI
Bulk Insert
Developer Activities
Last updated Apr 23, 2024
Bulk Insert
UiPath.Database.Activities.BulkInsert
Updates a table using Bulk operations using the specific database driver implementation. Will fallback to Insert Data Table if the database driver does not support Bulk operations.
Note: The Database activity package is now compatible with .NET 5 Windows.
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.
Connection Configuration
- ConnectionString - The connection string used to establish a database connection. This field supports only
String
variables. - ExistingConnection - An already open database connection. If such a connection is provided, the ConnectionString and SecureConnectionString properties are ignored. This field supports only
DatabaseConnection
variables. - ProviderName - The name of the database provider used to access the database. This field supports only
String
variables. - SecureConnectionString - The connection string used to establish a database connection as Secure String. This field supports only
SecureString
variables.
Input
- DataTable - The source DataTable for the items to be inserted. This field supports only
DataTable
variables. - TableName - 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
- AffectedRows - Stores the number of affected rows into an Int64 variable.