Sql Package Path
The path to the SqlPackage executable (sqlpackage.exe) that the generated SSDT deployment script uses to deploy the database projects.
When a path is set, the deployment PowerShell script runs SqlPackage from that path. When the setting is blank, the script locates sqlpackage.exe with vswhere.exe under the latest Visual Studio installation.
When to Change This Setting
Set it when SqlPackage is installed outside Visual Studio, or when the deployment must use a specific SqlPackage installation.
Related Settings
| Setting | Interaction |
|---|---|
| Output Path | The folder where the SSDT database projects that the script deploys are created |
| Visual Studio Version | Does not steer the blank-value lookup, which always takes the latest Visual Studio installation |
Notes
- This setting is part of the SSDT settings category.