DTS

SQLServerCentral Article

Exception handling in DTS

  • Article

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.

3.67 (3)

You rated this post out of 5. Change rating

2007-12-14 (first published: )

9,257 reads

SQLServerCentral Article

DTS and Global Variables

  • Article

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.

5 (2)

You rated this post out of 5. Change rating

2006-02-20

20,229 reads

SQLServerCentral Article

DTS Hashing

  • Article

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.

4 (1)

You rated this post out of 5. Change rating

2005-12-20

5,896 reads

SQLServerCentral Article

DTS Polling

  • Article

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.

You rated this post out of 5. Change rating

2005-12-05

8,490 reads

SQLServerCentral Article

Leveraging XP Excel , XML, and OPENXML for Data Imports

  • Article

DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.

5 (1)

You rated this post out of 5. Change rating

2005-11-22

10,917 reads

Blogs

Microsoft Announcement: Microsoft Fabric

By

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders

By

A customer asked about how they could organize their migration scripts in different ways...

Read the latest Blogs

Forums

Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...

SSIS DB

By sqlguru

I was thinking to add SSIS db to Always on AG group. So during...

Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?

By Rich Mechaber

I'm trying to create an SSIS package that will query a master control table...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers