DTC (Distributed Transaction Coordinator) service is an integral component of Microsoft Windows (on Windows 2003 and higher versions), and is also available as part of the SQL Server installation if a previous version of Windows is used. This service is responsible for coordinating distributed transactions, that is, transactions that involve multiple resource managers, such as databases, message queues, and file systems.
DTS (Data Transformation Services) is a SQL Server component which provides a set of tools that allow extracting, transforming and consolidating data from various sources (for example, Oracle database, Excel spreadsheet or Microsoft Access) into single or multiple destinations that use uniform SQL Server format.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité