| Term
| SQL Server 2000 Data Transformation Services
|
| Definition
| Data Transformation Services (DTS) in SQL Server 2000 contains a set of graphical tools and programmable objects which administrators and developers use to address data movement problems—including extraction, transformation, and loading (ETL) of data from multiple sources to multiple destinations. DTS packages comprise sets of constraints, tasks, and workflow operations. They can be collected and scheduled to run at the occurence of an event or periodically.
|
| See also
| SQL, SQL Server, SQL Server Reporting Services
|
| You may edit this definition to improve or extend it.
|
