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)

2007-12-14 (first published: )

9,219 reads

SQLServerCentral Article

Handling Zero Byte Files in DTS

  • Article

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.

3 (2)

2006-03-27

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

2006-02-20

20,152 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)

2005-12-20

5,871 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.

2005-12-05

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

2005-11-22

10,870 reads

Blogs

Daily Coping 4 Jul 2022

By

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

SQLServerCarpenter Tools

By

Over the past couple of years, I’ve developed several tools that I’ve been using...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

By

/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...

Read the latest Blogs

Forums

CAST AS DATE Assistance

By carlton 84646

Can someone let me know why I'm not able to use CAST method to...

Deploying a standalone Azure VM running SQL Server into an availability zone

By DBANewbie

If i deploy a standalone Azure VM running SQL Server into an availavility zone;...

SQL Server 2014 Question

By kazana

So I have inherited an older SQL 2014 Server and have been working on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers