In this article

Overview

Use the SQL Server Snap Pack to read and write objects from your SQL Server database.

The SQL Server Snap Pack supports Geospatial data types (Geography and Geometry). This Snap Pack enables you to insert, read, and select Geospatial data types within the SQL Server database.

Use Snaps in this Snap Pack to:

Get a list of tables in a database.
Lookup records in the target table and return a selected set of fields.
Fetch data from a database.
Execute SQL statements to delete, update, merge, or insert data into a specified table.

In this Section

TIMESTAMP datatype in SQL Server is not supported. According to the Microsoft official document, "The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."
The SQL Server Snaps express time up to the millisecond for date/time values, for example, 2019-11-05T00:34:55.007.
This Snap Pack supports the jTDS driver.

The SQL Server Snap Pack is upgraded to the Microsoft JDBC Driver 12.2.0.jre11. Existing pipelines that do not use the default driver (bundled with the SQL Server Snap Pack) are not impacted. If you want to use NTLM or other authentications with the latest default driver (where the DLL file is mandatory), then you must copy the DLL file to the Snaplex path.

Support Versions

This Snap Pack is tested against the following SQL Server versions:

11.00.2100
12.0.20008
13.0.4224.16
14.0.1000.169 (Windows AD)
16.0
This Snap Pack supports SQL Server 2008 to 2016.

Snap Pack History

Release	Snap Pack Version	Date	Type	Updates
November 2024	main29029	Nov 13, 2024	Stable	Updated and certified against the current SnapLogic Platform release.
August 2024	438patches28829	Nov 5, 2024	Latest	Reinstated support for the jTDS driver in the SQL Server Snap Pack.
August 2024	main27765	Aug 21, 2024	Stable	Updated and certified against the current Snaplogic Platform release.
May 2024	437patches27732	Aug 14, 2024	Latest	Fixed an issue with the SQL Server - Select Snap configured with an Ultra task to handle temporary database unavailability. The Snap now validates the database connection to ensure that it is reestablished after temporary database outages.
May 2024	437patches27328	Jul 30, 2024	Latest	Fixed an issue with the SQL Server Insert Snap that caused an error when inserting the infinity value into a `decimal`-type column.
May 2024	437patches27091	Jul 5, 2024	Latest	Fixed a case-sensitivity issue with the SQL Server—Bulk Load Snap that caused a `NullPointerException` when retrieving the `PATH` environment variable in a Windows environment. This change is applicable only to Windows, as environment variables are case-sensitive in Linux.
May 2024	main26341	May 8, 2024	Stable	Updated the Delete Condition (Truncates a Table if empty) field in the SQL Server - Delete Snap to Delete condition (deletes all records from a table if left blank) to indicate that all entries will be deleted from the table when this field is blank, but no truncate operation is performed.
February 2024	436patches26177	Apr 24, 2024	Latest	Fixed an issue with the SQL Server Snap Pack that displayed an error when numeric values with scale 0 were inserted into the database with DECIMAL or NUMERIC type columns, instead of inserting the value with decimal digits truncated. Fixed an issue with the SQL Server Snap Pack that displayed an error when fractional numeric values (numbers with a decimal point) were inserted into the database with an INT type column, instead of inserting the value with decimal digits truncated.
February 2024	436patches25757	Apr 3, 2024	Latest	Fixed an issue with the SQL Server - Insert Snap that previously displayed an error when attempting to insert a true or false value into a `TinyInt` datatype. The Snap now correctly inserts 1 or 0 for true or false in the table, respectively.
February 2024	436patches25548	Mar 21, 2024	Latest	Added support for XML and spatial types (Geography and Geometry) for SQL Server Snap Pack. Fixed an issue with the SQL Server - Insert Snap that displayed an error when an empty or blank string was passed as a value to an `integer-type` column.
February 2024	main25112	Feb 14, 2024	Stable	As of `main25112`, the SQL Server Snap Pack no longer supports the jDTS driver. If you are using the latest SQL Server driver versions (2014 and higher), we recommend you use the driver that is bundled with the SQL Server Snap Pack. Note that the older SQL Server versions are supported as is.
November 2023	main23721	Nov 8, 2023	Stable	Updated and certified against the current SnapLogic Platform release.
August 2023	434patches22758	Sep 11, 2023	Latest	Fixed an issue with the SQL Server Stored Procedure and Table List Snaps that caused no retries to be executed even if you select the number of retries in the UI when a custom JDBC driver was used.
August 2023	434patches22579	Aug 22, 2023	Latest	Improved the SQL Server Bulk Load Snap to reduce the chance of causing a deadlock error.
August 2023	main22460	Aug 16, 2023	Stable	The SQL Server - Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically.
May 2023	433patches22090	Aug 8, 2023	Latest	The SQL Server Stored Procedure and SQL Server Table List Snaps now support the retry functionality.
May 2023	433patches21808	Jul 13, 2023	Latest	The SQL Server Snap Pack is upgraded to the latest version of the Microsoft JDBC Driver 12.2.0.jre11 for SQL Server: Pipelines using the default JAR in the SQL server accounts might fail after the driver upgrade because the latest driver is backward-incompatible. To prevent your accounts from failing, reconfigure the URL properties field in account settings as follows: `trustServerCertificate = true` Pipelines NOT using the default driver (bundled with the SQL Server Snap Pack) will not fail. Note: This update will be a part of the stable distribution with the GA release on August 9, 2023. Learn more about the SQL Server driver upgrade: FAQ for Upgrading to SQL Server JDBC Driver 12.2.0 Fixed an issue with the SQL Server Insert Snap that was causing performance degradation between GA release 4.32 and 4.33 if the network connection between the Groundplex and the database server was slow.
May 2023	433patches21386	Jun 8, 2023	-	The SQL Server Snap Pack is upgraded to the latest version of the Microsoft JDBC Driver 12.2.0.jre11 for SQL Server: Pipelines using the default JAR in the SQL server accounts might fail after the driver upgrade because the latest driver is backward-incompatible. To prevent your accounts from failing, reconfigure the URL properties field in account settings as follows: `trustServerCertificate = true` Pipelines NOT using the default driver (bundled with the SQL Server Snap Pack) will not fail.
May 2023	433patches21119	May 15, 2023	Latest	Updated the Bulk Load Snap to preserve empty strings as empty strings and null as nulls.
May 2023	main21015	May 10, 2023	Stable	Upgraded with the latest SnapLogic Platform release.
February 2023	main19844	Feb 9, 2023