Integration Services (SSIS_

With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2020-07-17 (first published: 2019-01-02)

4,790 reads

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.

2018-12-03

2,109 reads

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...

At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...

Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...

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...

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?