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,604 reads

Blogs

SQL Server Sample Databases

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Power BI Monthly Digest – May 2020

By

This month we will likely have two releases of the Power BI Desktop. In...

Read the latest Blogs

Forums

The Challenges of Working Under Quarantine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Challenges of Working Under...

Upgrade SQL 2008R2 Cluster to SQL 2017

By AdamJSawyer

Hi, I've been asked to develop an implementation plan for upgrading a SQL 2008R2...

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers