Data Transformation Services

In SQL Server database application design and development DTS = Data Transformation Services

Allows you to automate routines that extract, transform, and load data from heterogeneous sources.

The DTS feature makes it easy to extract, transform, and load heterogeneous data using OLE DB, Open Database Connectivity (ODBC), or text-only files into any supported OLE DB database or multidimensional store. DTS also automates data transformation by allowing the user to import or transform data automatically on a regularly scheduled basis.

DTS has improved from previous releases in terms of usability and programmability. Developers can access and manipulate the operations of the multiphase data pump through interfaces that allow their programs to interact at multiple points during the progression of data transformations. The multiphase data pump allows for flexible handling of transformation and errors/failures. DTS also allows you to build "re-starts" into their DTS packages, with new, parameterized source select statements and improved error logging.

DTS packages can now be saved as Visual Basic-based code. This simplifies the development of DTS packages through programmatic interfaces. Also, when used in conjunction with the Visual SourceSafe™ version control system, DTS provides an alternative method of version control and backup for packages. Because packages can now call each other when they are executed, you get more flexibility in reusing existing packages. New tasks and custom transformations also extend your data-manipulation capabilities, performance, flexibility, and integration of DTS to products from other vendors.