SQL Server

The SQL Server connector allows you to execute direct queries against a SQL Server instance. It supports SQL Server Compact Edition, Express edition, Workgroup Edition, Enterprise Edition, Datacenter Edition.

Each of the tasks require a connection to an SQL data source, for more information on setting up and managing connections see the page Connecting to SQL Server.

Knowledge of SQL is required to use the tasks in this connector. You can find tutorials on SQL at W3 Schools.

Tasks

• Execute Query
• Execute Scalar Query
• Execute Select Query
• MS SQL Repeater

Articles and Sample Files

There is a workflow template and example available at the link below:

• Database