Create SQL Server plugin procedures

1 minute readExtensibilityDeveloper productivity
On this page

Plugin procedures can be used in procedure steps, process steps, and pipeline tasks, allowing you to orchestrate third-party tools at the appropriate time in your component, application process, or pipeline.


Execute a SQL file in SQL Server

Input parameters

Table 1. RunSQLFile input parameters
Parameter Description

Configuration name

Required. The previously defined configuration for the plugin.

Path to sqlcmd (DEPRECATED)

Absolute path to the SQL Server utility sqlcmd. Overrides the CLI path defined in the plugin’s configuration.


Required. The name of the server you want to connect to.

SQL Statement

Provide any SQL statement to run against the database.

Database name

Issues a USE db_name statement when sqlcmd is started.

Path to a SQL file

Absolute path to your SQL file.

Result (output property path)

Property name used to store the result of queries.