Actions

Use these commands to run SQL statements.

• Bulk Delete with SQL
  Deletes data in bulk in a database table based on the data in a data source.

• Bulk Insert with SQL
  Inserts data in bulk from a data source to a database table.

• Bulk Merge with SQL
  Merges data in bulk from a data source to a database table.

• Bulk Sync with SQL
  Synchronizes data in bulk from a data source to a database table.

• Bulk Update with SQL
  Updates data in bulk from a data source to a database table.

• Create Storage Adapter
  Creates a connection interface to a server or a local database.

• Execute ODBC Command
  This command is removed. Runs an Open DataBase Connectivity (ODBC) command that can return null, a scalar data or a data table.

• Execute SQL Instruction
  This command is removed. Runs an SQL instruction and returns information regarding the command's execution.

• Run SQL Command
  Runs an SQL statement against a connection with a database and returns the number of rows affected.

• Run SQL Procedure Reader
  Runs a stored procedure against a connection with a database and returns the data table originated from the stored procedure statement.

• Run SQL Reader
  Runs an SQL statement against a connection with a database and returns a data table and its number of columns and rows.

• Run SQL Scalar
  Runs an SQL scalar function.

• SQL Procedure
  Runs a stored procedure against a connection with a database and returns the number of rows affected.

• Terminate SQL Connection
  Terminates a connection with a database.