Server
The SSIS Server name to use for generated deployment script files.
For each generated SSIS project, BimlFlex writes a ssis-deploy.{project}.ps1 PowerShell script (plus a _ssis-deploy-all.ps1 runner) that deploys the compiled .ispac to the SSIS Catalog. This server name is used as the deployment destination in those scripts, and as the server for the optional catalog folder creation command. A blank value falls back to localhost.
When to Change This Setting
Set this to the SQL Server instance that hosts the SSIS Catalog whenever packages are deployed to a server other than the machine running the deployment scripts.
Related Settings
| Setting | Interaction |
|---|---|
| SSISDB | The catalog database name used in the deployment path |
| Folder | The catalog folder the projects are deployed into |
| Create Folder | Adds a command that creates the catalog folder on this server |
| SqlCmd Override | Overrides the sqlcmd connection used for the folder creation command |
Notes
- This setting is part of the SSIS settings category.
- The default value for this setting is
localhost.