31 Days of SSIS – DTSConfig Configuration (19/31)
31 Days of SSIS
The last two posts in the 31 Days of SSIS talked about the use of environmental variables...
2011-01-20
1,256 reads
StrateSQL
Time To Get Your #SQLRally Vote On!
It’s week two of voting for the upcoming SQLRally. This week, we are voting for the Database & Application Development sessions...
2011-01-19
453 reads
31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-19
2,206 reads
31 Days of SSIS – Environmental Variable(17/31)
31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages. For the...
2011-01-18
2,519 reads
XQuery for the Non-Expert – @Variable Use
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In a...
2011-01-17
2,700 reads
31 Days of SSIS – 10 Things About Expressions (16/31)
31 Days of SSIS
Sixteen days in and we are past the half way point for the 31 Days of SSIS...
2011-01-16
986 reads
31 Days of SSIS – Every Which Way Outputs (15/31)
31 Days of SSIS
Saturday morning and you can watch your favorite cartoon, or jump into some fun with SSIS. Today...
2011-01-15
575 reads
PASSMN January Meeting Announced
The details are up and we have the meeting planned for January for the Minnesota SQL Server User Group (PASSMN). ...
2011-01-15
610 reads
31 Days of SSIS – Instant Excel Spreadsheet (14/31)
31 Days of SSIS
It’s day fourteen of the 31 Days of SSIS blog series. It’s also Friday, so I’m taking...
2011-01-14
612 reads
Last Call for Speakers 24 Hours of PASS
Calling for Presenters!Today is the day! If you were planning to submit a session for the next 24 Hours of...
2011-01-14
792 reads
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
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