- 3 minutes to read

SqlPackageExecutable - System Parameter

The System parameter SqlPackageExecutable is used to provide the path to the SQL Package executable (SQLPackage.exe), also called DACFRAMEWORK and/or DACPAC, for the currently installed version of Microsoft SQL Server. The SQL binaries must be installed, and the path must point to the same physical path on all Nodinite application servers with either the Install and Update Tool and/or the Logging Service.

System Parameter Name Data Type Values/Example Comment
SqlPackageExecutable string Path to SQLPackage.exe You must use a version that matches the highest used version of SQL Server

This feature was introduced with version 4.0

Examples

The following SQL Versions are supported by Nodinite

64 Bit

Version of Folder SQL Version Possible path
105 SQL Server 2008 R2 "C:\Program Files\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe"
110 SQL Server 2012 "C:\Program Files\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe"
120 SQL Server 2014 "C:\Program Files\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe"
130 SQL Server 2016 "C:\Program Files\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe"
140 SQL Server 2017 "C:\Program Files\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe"
150 SQL Server 2019 "C:\Program Files\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe"

32 Bit

Version of Folder SQL Version Possible path
105 SQL Server 2008 R2 "C:\Program Files (x86)\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe"
110 SQL Server 2012 "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe"
120 SQL Server 2014 "C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe"
130 SQL Server 2016 "C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe"
140 SQL Server 2017 "C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe"
150 SQL Server 2019 "C:\Program Files (x86)\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe"

However, just because you have a folder with one of these identifiers, does not mean you have a SQL Server instance of that version installed; some folders are laid down by newer versions for backward compatibility reasons, added by Visual Studio and other tools, or are left behind after an instance has been removed or upgraded.

One way to get the installed version of SQL Server:
Installed SQL Server Version


Frequently asked questions

Common problems and FAQ for the System Parameters not found on this page can be found in the troubleshooting page.

How do I change the value?

Changing a value for any of the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.


Next Step

Administration