Data Transformation Services (DTS) in SQL Server 2000. By Diane Larsen Euan Garden, contributor September 2000 Summary: Database administrators often import, export, and transform data in support of tasks such as data consolidation, archiving, and analysis; for application development purposes; and for database or server upgrades.
Data Transformation Services (DTS) in SQL Server 2000 provides a set of graphical tools and programmable objects to help administrators and developers solve data movement problems, including the extraction, transformation, and consolidation of data from disparate sources to single or multiple destinations. Sets of tasks, workflow operations, and constraints can be collected as DTS packages that can be scheduled to run periodically or when certain events occur.
Looping, Importing and Archiving. One of the most common things asked for by people using DTS is the ability to loop through a directory and process files along the way.
This is how I do it. Although it may look a little complicated for what is quite an easy task it isn't trust me.. There are 7 main parts to this package. The destination table is created if it does not exist already We define our GlobalVariables. We also need to check and make sure that the directories for the file location and the archiving location are correct. Import multiple txt files. SQL Server Integration Services.