SQLServerCentral.com Articles tagged DTS

Working with DTS in SQL Server 2008

Mon, 15 Feb 2010 07:00:00 UT

How to continue using DTS packages in a SQL 2008 environment.

On Error () Logging by Using Event Handlers

Fri, 26 Jun 2009 06:00:00 UT

Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.

Powering up DTS with PerlDTS

Mon, 22 Dec 2008 07:00:00 UT

This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.

Migrating DTS Packages to Integration Services

Fri, 07 Nov 2008 07:00:00 UT

In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.

VBscript hacks for DTS packages

Fri, 11 Jul 2008 06:00:00 UT

This article is about using VBscript hacks to overcome two limitations of DTS packages.

Yet another way to include portability on DTS packages

Thu, 10 Apr 2008 06:00:00 UT

An proposal about using simple server name resolution and INI files to make a DTS package portable.

Conditional Flow in DTS

Wed, 19 Mar 2008 06:00:00 UT

While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.

Five Realtime DTS Examples

Fri, 08 Feb 2008 07:00:00 UT

SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server 2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment.

Top 10 SQL Server Integration Services and DTS tips

Wed, 02 Jan 2008 07:00:00 UT

Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005.

The Dynamic Process of Loading Data

Mon, 31 Dec 2007 07:00:00 UT

When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.

Overview of DTS Packages

Fri, 21 Dec 2007 07:00:00 UT

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.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Exception handling in DTS

Fri, 14 Dec 2007 07:00:00 UT

While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.

Monitoring on a Budget

Mon, 19 Nov 2007 07:00:00 UT

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this

Migrating SQL Server 2000 DTS Packages Across Environments

Tue, 09 Oct 2007 06:00:00 UT

Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.

Maintain DTS packages in SQL Server 2005

Thu, 05 Jul 2007 06:00:00 UT

Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.

Conditional Flow in DTS

Wed, 19 Mar 2008 06:00:00 UT

Five Realtime DTS Examples

Fri, 08 Feb 2008 07:00:00 UT

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

The Dynamic Process of Loading Data

Mon, 31 Dec 2007 07:00:00 UT

Exception handling in DTS

Fri, 14 Dec 2007 07:00:00 UT

Managing DTS packages - Editing, Scheduling, and Viewing Package Logs

Fri, 06 Oct 2006 06:00:00 UT

In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.

Executing a Package from Visual Basic

Fri, 18 Aug 2006 06:00:00 UT

So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.

Committing imports in SQL Server a little at a time

Thu, 03 Aug 2006 06:00:00 UT

A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.

Copying DTS Packages To a Different Server

Fri, 05 May 2006 06:00:00 UT

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!

Handling Zero Byte Files in DTS

Mon, 27 Mar 2006 06:00:00 UT

SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.

DTS and Global Variables

Mon, 20 Feb 2006 07:00:00 UT

SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.

SED and the Big Bad UNIX File

Tue, 10 Jan 2006 07:00:00 UT

One would think that when you have to work with Unix text files, they would be the same as Windows text files. That is not quite the case and Peter Ward brings us a look at how this caused a problem in DTS and a way you can fix it.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

DTS Hashing

Tue, 20 Dec 2005 07:00:00 UT

DTS is a great tool in SQL Server 2000 for easily setting up jobs to import or export data. But it can also have security risks. New author Alex Kersha brings us a simple security technique to be sure that you are properly executing your DTS packages in a secure manner.

Granting Execute Access to All Stored Procedures to a Given User

Tue, 13 Dec 2005 07:00:00 UT

A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.

DTS Polling

Mon, 05 Dec 2005 07:00:00 UT

Lots of packages exist that will import data files for you, even if you do not know the file name ahead of time. But most of them expect the files to be there. New author Andre Quitta brings us a technique he has for checking to see if the files are even there before importing them.

Data Migration : Step by Step

Fri, 25 Nov 2005 07:00:00 UT

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.