Activities
latest
false
Banner background image
Developer Activities
Last updated Mar 15, 2024

Insert

UiPath.Database.Activities.InsertDataTable

Inserts a compatible DataTable variable in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will not be completed successfully and all the written rows will be saved.

Note: The Database Activity Pack is now compatible with .NET 5 Windows.
Important: The Insert activity uses a DataAdapter to automatically generate the proper insert/update queries, based on the database schema. In order to generate the queries, ODBC implements standard schema calls. Make sure the database you are using implements standard schema calls, otherwise the activity might not work properly.

Properties

Common
  • ContinueOnError - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the 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.

    Note: If this activity is included in Try Catch and the value of the ContinueOnError property is True, no error is caught when the project is executed.
  • 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.
  • Existing Connection - An already opened database connection obtained from the Connect or Start Transaction activities. 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 DataTable variable that will be inserted into the Table. The DataTable columns' name and description must match the ones from the database table.
  • TableName - The SQL table in which the data is to be inserted. This field supports only String variables.
Misc
  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
Output
  • AffectedRecords - Stores the number of affected rows into an Int32 variable.
  • Properties

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.