SQL IS Parameters

Previous SQL RS Parameters	Tools Parameters Next

The parameters that are useful for a Integration Services Install are given below. The parameters cover both the basic install and the provisioning that can be performed by SQL FineBuild.

If you are happy that the default value for a given parameter is right for your organisation then you do not need to provide that parameter.

When you run SQL FineBuild you should always provide a /AdminPassword: parameter giving your own password in order to log on automatically after a reboot.

Index

The parameters are divided into the following sections:

• Basic Install
• Account Provisioning
• Cluster Provisioning
• IS Configuration Provisioning
• IS Scaleout Provisioning

---

Basic Install

Parameter	Default	Comment
/SetupSQLIS:	(none)	Set to YES to install Integration Services (DTS for SQL2005)

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/ISSvcStartupType:	Automatic	(SQL2008 and above) SSIS service startup type
/ISAutoStart:	1	(SQL2005 only) SSIS service startup type

Index

---

Account Provisioning

Parameter	Default	Comment
/IsSvcAccount:	(none)	Name of SSIS Service Account
/IsSvcPassword:	(none)	Password for SSIS Service Account

Index

---

Cluster Provisioning

This section shows the parameters you can add to the Basic Install in order to install a Integration Services Cluster. These parameters are only valid if you are installing on to a Windows Cluster.

Parameter	Default	Comment
/SetupSSISCluster:	No	Setup SSIS Cluster

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/ClusISIPSuffix:	(calculated)	TCP final octet for IS Cluster address
/ClusISSuffix:	IS	Suffix added to Windows Cluster Name to form the Integration Services Cluster Name

Index

---

IS Configuration Provisioning

This section shows the parameters you can add to the Basic Install to configure a Integration Services.

Parameter	Default	Comment
/SetupSSISDB:	Yes	Install SSIS Catalogue Database

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/SSISDB:	SSISDB	Name of SSIS Catalogue database
/SSISPassword:	(saPwd)	Password for SSIS Catalog Database
/SSISRetention:	30	Number of days to retain Package History in SSISDB

Index

---

IS Scaleout Provisioning

This section shows the parameters you can add to the Basic Install for IS Scaleout for SQL Server 2017 and above.

Parameter	Default	Comment
/SetupISMaster:	(none)	Setup IIS Master Scaleout service
/SetupISWorker:	(none)	Setup IS Worker Scaleout Service
/IsMasterSvcAccount:	(none)	Name of SSIS Scaleout Master Service Account
/IsMasterSvcPassword:	(none)	Password for SSIS Scaleout Master Service Account
/ISMasterSvcThumbprint:	(none)	Tumbprint of IS Master Scaleout Service
/IsWorkerSvcAccount:	(none)	Name of SSIS Scaleout Worker Service Account
/ISWorkerSvcCert:	(none)	Path to IS Master certificate file
/IsWorkerSvcPassword:	(none)	Password for SSIS Scaleout Worker Service Account
/ISWorkerSVCMaster:	(none)	Name of IS Master Scaleout Service

The following parameters can normally be left at their default values:

Parameter	Default	Comment
/ISMasterSvcStartupType:	Automatic	SSIS Scaleout Master service startup type
/ISWorkerSvcStartupType:	Automatic	SSIS Scaluout Worker service startup type
/TCPPortISMaster:	8391	TCP Port for IS Master Scaleout Service

Index

---

Copyright FineBuild Team © 2021. License and Acknowledgements

Previous SQL RS Parameters	Top	Tools Parameters Next