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.

Optional properties:

Property Name Description
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.