Skip to main content

Import From DataTable

Description​

It imports the data from Data Tables to a database and returns the number of rows affected.

Properties​

Input​

  • Column Mapping – It enables column names in a DataTable different from those in the target data source.
  • Connection String – It specifies the connection string to establish a database connection.
  • Data Table – The DataTable variable from which data will be imported to the database.
  • Database Context – It specifies the Database context variable.

    Note: If the Database Context variable used here returns by the Connect activity, it ignores all properties (Connection String and Provider Name) related to the database connection.

  • Provider Name – It specifies the name of the database provider to access the database.
  • Table – It specifies the table in the database in which the data gets imported.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – By default, activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Optional​

  • Continue On Error – 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.

    Note: If this activity is included in Try Catch and the value of this property is True, no error is caught when the project is executed.

Output​

  • Records Affected – Number of records inserted in the specified database table.

Example​

Download Example

Import From Datatable