Jonathan Stokes

DTS Standards

SQL Server 2000 brought us DTS, a new way of working with data movement for SQL Server DBAs. However, unlike Integration Services and Project REAL, there weren't any great standards for working with this tool and building portable solutions was hard. Jonathan Stokes brings us a great article on how you can create a standard structure for your packages and make them more portable.

5 (1)


8,606 reads


Introducing system-versioned ledger tables


As long-time readers of this blog know, I’m a big fan of temporal tables,...

Daily Coping 15 Sep 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My upcoming Online Trainings and Speaking Engagements


Over the next few weeks I have again some online training and speaking engagements...

Read the latest Blogs


Subselect / Group by - Error multiple values

By bent

Hi there! I need to update n attribute in the table "rm_request" by summing...

Query with a column containing JSON text

By Roust_m

Hi I have a table MyFiles with columns Id, FileName, FolderName, KeyPairs. The last...

Parsing XML data

By maijoe

Hi all, I need help to extract data from a xml field. My data...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers