Creating a 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.

Copyright © 2013–2016 Serena Software, Inc. All rights reserved.