Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,950 reads
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,950 reads
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,737 reads
It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest...
2009-09-26
548 reads
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-25
1,907 reads
In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.
2009-09-24
13,179 reads
Today we have a guest editorial from Tim Mitchell that looks at the stereotypical geek. Have you worked with one? Is it harder to manage technical people? Or is it the job? Read Tim's thoughts and let us know if you agree.
2009-09-24
153 reads
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
2009-09-23
3,475 reads
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-21
1,246 reads
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
2009-09-21
1,239 reads
I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. ...
2009-09-19
598 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
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? See possible answers