Create SQL Server plugin procedures

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.

RunSQLFile

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.
Server	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.