The Microsoft SQL Server SQLCMD utility is a command line application that exposes the management features of SQL Server. It comes with Microsoft SQL Server.
To use the plugin's step, open the process designer and navigate to Database > SQLCmd in the Tools pane.
This plugin has the Run SQLCMD Scripts step for you to add to your processes:
Run SQLCMD Scripts step
This step runs sqlcmd scripts in sorted order.
Required properties: None
Note: Although none of the fields are enforced as required, you must enter as many fields as are required to run the scripts in your environment.
|Directory Offset||Enter the directory offset relative to the current working directory where the step should run.|
|SQLCmd Executable Path||Enter the full path to the sqlcmd executable if it is not on the path.|
|Server\Instance||Enter the server or instance to connect to.|
|Username||Enter the username for the scripts to be run as.|
|Password||Enter the password of the user for the scripts to be run as.|
|Password Script||Use this instead of the Password field if the password is stored in a property.|
|Use Trusted Connection||Select this to use a trusted connection instead of user/password.|
|Use Dedicated Admin Connection||Select this to use a dedicated administrative connection.|
|DB Name||Enter the name of the database to use.|
|SQL File Includes||Enter a new-line-separated list of file filters to determine the SQL scripts to be executed. Use this when order between files is unimportant.|
|Exclude Files||Enter a new-line-separated list of file filters to determine the files to be excluded from the above selection. Use in conjunction with includes. If you are using a list in the SQL Files field, this field is ignored.|
|SQL Files||Enter a new-line-separated list of files to be executed. Use this when order between files is important.|
|Login Timeout||Enter the number of seconds before a sqlcmd login to the OLE database provider times out when you try to connect to a server. The default is 8 seconds.|