Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-06-08 (first published: 2017-06-01)

489 reads

List Expressions and Values of Variables in SSIS package

Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-11-17 (first published: 2015-10-18)

2,104 reads

Blogs

A while back I wrote a quick post on setting up key mappings in...

In 100 years a lot of what we take to be true now will...

hi , i hear more and more that we have too many connections to...

Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...

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

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?