Follow-On Topics

Related Topics

# About the Microsoft SQL Server Trigger Tool

The Microsoft SQL Server Trigger tool is used to create a Task Step that utilises the SQL Server trigger functionality to create a trigger on a table of a specified SQL data source. When a specified data modification is attempted, such as an attempt to add or delete a table row, the trigger then causes a Task to run.

The trigger creates virtual tables for inserted/updated and deleted rows which may be mapped to Task variables so that the data may be used in other Steps within the Task.

If a Database Query (ODBC) or Database Query (OLEDB) step is used within the Task to retrieve a recordset from the SQL data source, then the memory feature may be used in a subsequent Step to memorise all of the data into a Repository.

## Features

|  | A Trigger may be activated when any row is updated, deleted or a new row inserted.

|  | A Trigger may be activated when specified columns are updated.

|  | Values of updated, deleted or new rows in the virtual tables may be mapped to variables for use in other Steps within the Task.

## Supported SQL Server Versions

Supported SQL Server editions are listed below:

|  | Microsoft SQL Server 2005

Express, Standard, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008

Express, Standard, Workgroup, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2008 R2

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2012

Express, Standard, Web, Workgroup, Parallel Data Warehouse, Fast Track, Datacenter, Evaluation, Business Intelligence, Developer, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2014

Express, Evaluation, Standard, Web, Developer, Business Intelligence, and Enterprise editions

32- or 64-bit

|  | Microsoft SQL Server 2016

Express, Evaluation, Standard, Developer, and Enterprise

64-bit

|  | Microsoft SQL Server 2017

Express, Evaluation, Standard, Enterprise, Developer, and Web Edition

64-bit

Copyright © 2018 Quadrant Software B.V. All rights reserved.