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.
Run SQLCMD Scripts step
The Run SQLCMD Scripts step runs sqlcmd scripts in sorted order.
To use the step, open the process designer and navigate to Database > SQLCmd in the Tools pane.
The step has no required properties. The following table describes the step's optional properties.
Note: Although none of the fields are enforced as required, 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 run. Use this when the order of 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.|