Question.
What is dts
Data
Transformation Services, or DTS, is a set of objects and utilities to
allow the automation of extract, transform and load operations to or
from a database. The objects are DTS packages and their components, and
the utilities are called DTS tools. DTS was included with earlier
versions of Microsoft SQL Server, and was almost always used with SQL
Server databases, although it could be used independently with other
databases.
DTS allows data to be transformed and loaded from heterogeneous sources using OLE DB, ODBC, or text-only files, into any supported database. DTS can also allow automation of data import or transformation on a scheduled basis, and can perform additional functions such as FTPing files and executing external programs. In addition, DTS provides an alternative method of version control and backup for packages when used in conjunction with a version control system, such as Microsoft Visual SourceSafe .
DTS allows data to be transformed and loaded from heterogeneous sources using OLE DB, ODBC, or text-only files, into any supported database. DTS can also allow automation of data import or transformation on a scheduled basis, and can perform additional functions such as FTPing files and executing external programs. In addition, DTS provides an alternative method of version control and backup for packages when used in conjunction with a version control system, such as Microsoft Visual SourceSafe .
No comments:
Post a Comment