In this article, Brian Knight shows you the different ways to load data in DTS and how to optimize the Data Pump task for data loads. He also examines performance numbers on other data loading tasks in DTS.
2001-08-02
7,465 reads
DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.
2001-08-09
5,937 reads
Steve Jones reviews the premier DTS reference for SQL Server 2000.
2001-06-06
12,567 reads
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,332 reads
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,224 reads
