Define DTS service in SQL Server

Define DTS service in SQL Server.

- DTS stands for Data Transformation Services.

- It is used to import and export data between heterogeneous data source.

- A DTS package can not only transfer data from a table to another, but can also specify a query as a source of data.

- It is a set of graphical tools and programmable objects which lets you extract, transform and consolidate data from disparate sources into single or multiple destinations.

Following table shows the important information about DTS tools, features and concepts.

TopicDescription
DTS BasicsIt describes the capabilities of DTS and solves the business problems.
DTS ToolsIt describes the graphical tools supplied with SQL Server 2000 which is mostly used to build the DTS package.
DTS Package ElementsIt describes the main components of a package, such as DTS tasks and transformations.
Sharing Meta DataIt explains how to use SQL Server 2000 Meta Data Service with DTS to track package data in a data mart or data warehouse.
Managing a DTS packageIt explains the basics of package management, including creating, editing, saving, deleting and executing packages.
What is Replication in SQL Server?
Replication allows creating copies of data in separate databases along with keeping all databases........
Define Bulk Copying and Distributed Queries of SQL Server
Bulk copying is used to transfer large amount of data. Distributed Queries in SQL server are used to reference heterogeneous data source.......
Define SQL Server Agent
SQL server agent is important service of the server where instances of SQL server are running.........
Post your comment