This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem
You can read the previous posts here. To finish up (I think), I want to share a networking technique I stumbled on a few years ago, and talk about one more good reason to network.
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
This article is final part of a 5 part series that explores the SSIS features introduced in SQL Server 2008. The final artilce in the series will explore VSTA support for the Script Task and Script Component, Import And Export Wizard Enhancements and how SSIS leverages SQL Server 2008 features.
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
In this month's energy update Steve Jones takes a look at more efficient building practices to increase energy efficiency.
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...
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'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? See possible answers