Krista Olson

Interests: Building Quality databases with a purpose! Also mom to two busy kids, and President of McDill Lake District

Using SSIS to export data from a 64 bit server to Excel 2007

Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

You rated this post out of 5. Change rating

2012-12-04

7,617 reads

I haven’t done one of these in awhile, but I saw an article recently...

In last months one of the scenarios where you can use AI has been...

Comments posted to this topic are about the item Missing the Jaro Winkler Distance

Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral...

Comments posted to this topic are about the item Doing Good at SQL Server...

I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:

SELECT JARO_WINKLER_DISTANCE('tim', 'tom')

I get this error message:

Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.

What is wrong?