DTS

Technical Article

Migrating DTS Packages to Integration Services

  • Article

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.

2008-11-07

5,110 reads

SQLServerCentral Article

Migrating SQL Server 2000 DTS Packages Across Environments

  • Article

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.

3.13 (8)

2007-10-09

6,197 reads

SQLServerCentral Article

Conditional Flow in DTS

  • Article

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.

4 (4)

2008-03-19 (first published: )

10,170 reads

SQLServerCentral Article

Five Realtime DTS Examples

  • Article

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.

4.5 (2)

2008-02-08 (first published: )

17,400 reads

SQLServerCentral Article

The Dynamic Process of Loading Data

  • Article

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.

3.13 (8)

2007-12-31 (first published: )

9,925 reads

Blogs

Daily Coping 23 May 2022

By

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

Cloud Formations – A New MVP Led Training Initiative

By

Hello, data friends! Let me spread a few words about the new MVP led...

Daily Coping 20 May 2020

By

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

Read the latest Blogs

Forums

How to change datasource on multiple reports deployed to power bi report server

By olegserdia

Each query in power bi report has it's own connection string. If something wrong...

Call multiple packages based on result set of the query

By komal145

Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...

LDF is not automatically shrinked with simple recovery mode

By mnemonicator

Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers