- 4 minutes to read

SqlPackageExecutable - System Parameter

The System parameter SqlPackageExecutable is used by the Nodinite Logging Service and contains the local path of 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.

When the time has come to create a new Nodinite Log Database, the Nodinite Logging Service uses the sqlpackage.exe to install and register the new database. If there is any problem with the DACFRAMEWORK, the new database will not be created and data will continue to grow in the existing online Log Database.

Download and install the latest 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

Example Paths for SqlPackage

The following SQL Versions are supported by Nodinite

64 Bit

Version of Folder SQL Version Possible path
160 SQL Server 2019 "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" This is where 161 versions gets installed by default
150 SQL Server 2019 "C:\Program Files\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe"
140 SQL Server 2017 "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe"
130 SQL Server 2016 "C:\Program Files\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe"
120 SQL Server 2014 "C:\Program Files\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe"
110 SQL Server 2012 "C:\Program Files\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe"
105 SQL Server 2008 R2 "C:\Program Files\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe"

32 Bit

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

Warning

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
Here's an example of a version of SQL Server.

Info

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


Frequently asked questions

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

How do I change the value?

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

You must have a user with the same password in the master or target server

If you encounter a problem deploying the databases using the SQLPackage.exe, for example, the exception listed below; Update SSMS to 17.3 or later.


You must have a user with the same password in master or target server

Download and install the latest sqlpackage


Next Step

Administration