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
Parameter | Description |
---|---|
Configuration name |
Required. The previously defined configuration for the plugin. |
Path to sqlcmd (DEPRECATED) |
Absolute path to the SQL Server utility |
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 |
Path to a SQL file |
Absolute path to your SQL file. |
Result (output property path) |
Property name used to store the result of queries. |