DTS

SQLServerCentral Article

DTS Standards

  • Article

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)

You rated this post out of 5. Change rating

2005-11-21

8,615 reads

SQLServerCentral Article

Overview of DTS Packages

  • Article

While SQL Server 2005 is greatly changing the paradigm of ETL with Integration Services, SQL Server 2000 and DTS will be here for some time to come. New author Rama Nageshwara brings us an overview of this fantastic data movement toolset.

4 (4)

You rated this post out of 5. Change rating

2007-12-21 (first published: )

28,825 reads

SQLServerCentral Article

Have You Been Told Today

  • Article

SQL Server 2000 has a great job and alert subsystem, but it doesn't do everything. There are times when you want to be notified that something has completed, or not completed. New author Frank Loschiavo brings us a way to ensure that when you run a query you are notified if and when it completes.

3 (1)

You rated this post out of 5. Change rating

2005-10-20

6,136 reads

SQLServerCentral Article

Generating Test Data with Integration Services

  • Article

DTS was one of the most amazing new features of SQL Server 7 and in SQL Server 2005 it has been renamed to Integration Services. This component has some incredible new capabilities, many of which come at a steep learning curve. New author Kristian Wedberg brings us a basic article and some code on how you can SSIS to generate test data.

5 (1)

You rated this post out of 5. Change rating

2005-08-29

14,969 reads

SQLServerCentral Article

Importing The Latest File In A Folder Via DTS

  • Article

Using the Dynamic Properties Task in SQL Server 2000 DTS is a great way to build a flexible package that can handle a variety of situations. Things are much improved in SQL Server 2005 Integration Services, but many of you will need to solve a common problem until you can upgrade. New author David Jackson brings us a technique for finding and processing the latest file in a folder.

5 (2)

You rated this post out of 5. Change rating

2005-04-12

12,294 reads

SQLServerCentral Article

More Portable DTS Packages

  • Article

There have been a few articles over time on how you can build DTS packages in SQL Server 2000 that are easily moved from one server to another. New author Tito David brings us another technique that not only migrates packages easily between servers, but between your development and production environments.

You rated this post out of 5. Change rating

2005-04-07

9,285 reads

SQLServerCentral Article

Flexible DTS Packages with Perl

  • Article

SQL Server 2000 DTS was a revolutionary programming environment, but one that was not without a few quirks. As often found with many Microsoft products, there were sections in your packages where things were hard coded, making them less flexible. New author Jeremy Brown brings us a look at how you can build extremely flexible packages using Perl.

You rated this post out of 5. Change rating

2005-04-05

11,040 reads

SQLServerCentral Article

The Multi Phase Data Pump

  • Article

SQL Server 2000 has an amazing ETL tool in Data Transformation Services that is included at no charge, something none of the other database vendors include. DTS has great flexibility to make your job easier, but it has some quirks in this version. The Multi Phase Data Pump is hidden inside the tool, but can provide a great programming environment and Dinesh Asanka brings us a look at what you can do wit this tool.

5 (1)

You rated this post out of 5. Change rating

2005-03-29

11,984 reads

Blogs

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025

By

I’m excited to announce that on June 17 – 18, 2025, I’ll be running...

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

Read the latest Blogs

Forums

importing from PowerQuery... but with multiple powerqueries

By pietlinden

I finally got the PowerQuery source to "show" in SSIS (so I can see...

Third party backup softwares

By ashrukpm

Hi Team, Can you someone suggest a few good third part backup tools, with...

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers