Clean Output Path
Specifies whether the output folder for the SSDT (SQL Server Data Tools) project should be cleared during the build process.
When enabled (the default), the SSDT output folders (both the current output location and the build target) are deleted before the projects are generated, so the output contains only files from the current build. When disabled, existing files are kept and the generated files are written over or alongside them.
When to Change This Setting
Keep the default Y for a reproducible output that always reflects the current metadata. Disable it when the output folders carry files that must survive a rebuild, for example manually adjusted default artifact scripts kept in place by Overwrite External Table Defaults, whose keep-existing behavior is defeated if the folder is cleaned first.
Related Settings
| Setting | Interaction |
|---|---|
| Output Path | The folder that is cleaned and regenerated |
| Overwrite External Table Defaults | Keep-existing behavior for default artifact files only applies when the folder is not cleaned |
Notes
- This setting is part of the SSDT settings category.
- The default value for this setting is
Y.