SqlCmd Override
Override the sqlcmd connection in the Create SSIS Catalog folder in the deployment script.
When Create Folder is enabled, the generated deployment script creates the catalog folder by running sqlcmd with integrated security against the configured server and catalog database (& "sqlcmd" -E -S {server} -d {SSISDB}). A value entered here replaces that command, and the folder creation query is appended to it.
When to Change This Setting
Keep the default (blank) when integrated security against the deployment server is available. Provide an override to use a different authentication method or a specific sqlcmd invocation for the folder creation step.
Related Settings
| Setting | Interaction |
|---|---|
| Create Folder | Enables the folder creation command this override applies to |
| Server | The server used by the default sqlcmd command |
| SSISDB | The database used by the default sqlcmd command |
Notes
- This setting is part of the SSIS settings category.