- 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.

Download and install sqlpackage

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

Remember to Uninstall the older versions, if you install a newer version


Frequently asked questions

Additional solutions to common problems and the FAQ for the Nodinite System Parameters exists in the Troubleshooting user guide.

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