Microsoft SQL Server SQLCmd - Process Steps

• Run SQLCmd scripts

Run SQLCmd scripts

Run SQLCmd scripts in sorted order

Name	Type	Description	Required
Additonal Arguments	String	Specify additional command line arguments in the format: FLAG [VALUE]. Each Flag, and poential Value, should be separated with a space. Example: -v MyVar1=something or -N.Separate each argument pair with a new line or semicolon.	No
DB Name	String	The name of the DB to use.	No
Directory Offset	String	The directory offset relative to the current working directory where the step should run.	No
Exclude Files	String	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 using list it is ignored.	No
Login Timeout	String	Specifies the number of seconds before a sqlcmd login to the OLE DB provider times outwhen you try to connect to a server.Defaults to 8 sec if not specified.	No
Password	Password	The password of the user for the scripts to be run as.	No
Password Script	String	Use this instead of the Password field if the password is stored in a property.	No
SQL File Includes	String	A new line separated list of file filters to determine the sql scripts to be executed. Use this when order between files is unimportant.	No
SQL Files	String	A new line separated list of files to be executed. Use this when order between files is important.	No
SQLCmd Executable Path	String	The full path to the sqlcmd executable if it is not in the current working directory, and if it is not specified in the PATH environment variable.	No
Server\Instance	String	The server\instance to connect to.	No
Use Dedicated Admin Connection	Boolean	Select here to use a dedicated admin connection.	No
Use Trusted Connection	Boolean	Select here to use a trusted connection instead of user/password.	No
User name	String	The user name for the scripts to be run as.	No