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)

2005-11-21

8,606 reads

Blogs

Introducing system-versioned ledger tables

By

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

Daily Coping 15 Sep 2021

By

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

My upcoming Online Trainings and Speaking Engagements

By

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

Read the latest Blogs

Forums

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers