DTS

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,062 reads

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,778 reads

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

19,808 reads

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,799 reads

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,469 reads

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,690 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Rebuild vs Reorganize

By sergey.gigoyan

Comments posted to this topic are about the item Rebuild vs Reorganize

Increase Query Speed with Covering Indexes

By steve@thesqlguy.com

Comments posted to this topic are about the item Increase Query Speed with Covering...

Data for Defense

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data for Defense

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers