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)

2005-11-21

8,606 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)

2007-12-21 (first published: )

27,820 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)

2005-10-20

6,131 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)

2005-08-29

14,611 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)

2005-04-12

12,244 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.

2005-04-07

9,240 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.

2005-04-05

10,900 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)

2005-03-29

11,951 reads

Blogs

Updates from Coping Tips

By

I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

What I’ve learned in my first 100 days with a consulting group

By

In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?

By

With Power BI continuing to get many great new features, including the latest in...

Read the latest Blogs

Forums

What's your opinion about Google Cloud SQL?

By mavalgreb

Hi, I wonder what your opinion about Google Cloud SQL is! We are a...

How To Flatten JSON Data?

By Chris Wooding

I receive data in JSON files and for one particular type of data I...

Last Cube Refresh Showing Wrong Time

By Shivs

Hi I have a tabular model and have been asked to retrieve the last...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers