Skip to main content

MSSql components

tMSSqlBulkExec Offers gains in performance while executing the Insert operations to a Microsoft SQL Server database.
tMSSqlClose Closes a transaction in the MSSql databases.
tMSSqlColumnList Lists all column names of a given MSSql table.
tMSSqlCommit Commits in one go, using a unique connection, a global transaction instead of doing that on every row or every batch and thus provides gain in performance.
tMSSqlConnection Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
tMSSqlInput Executes a DB query with a strictly defined order which must correspond to the schema definition.
tMSSqlLastInsertId Retrieves the last primary keys added by a user to a MSSql table.
tMSSqlOutput Executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the Job.
tMSSqlOutputBulk Prepares the file to be used as parameter in the INSERT query to feed the MSSql database.
tMSSqlOutputBulkExec Gains in performance during Insert operations to a Microsoft SQL Server database.
tMSSqlRollback Cancels the transaction commit in the MSSql database and thus avoids to commit part of a transaction involuntarily.
tMSSqlRow Acts on the actual DB structure or on the data (although without handling data).
tMSSqlSP Offers a convenient way to centralize multiple or complex queries in a database and calls them easily.
tMSSqlTableList Lists the names of a given set of MSSql tables using a select statement based on a Where clause.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!