Data Transformation Services
E307899
Data Transformation Services (DTS) was an early Microsoft SQL Server component used to extract, transform, and load (ETL) data between heterogeneous data sources before being superseded by SQL Server Integration Services.
All labels observed (1)
| Label | Occurrences |
|---|---|
| Data Transformation Services canonical | 4 |
How this entity was disambiguated
This entity first appeared as the object of triple T2880504 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Data Transformation Services Context triple: [SQL Server Integration Services, replaced, Data Transformation Services]
-
A.
Data Quality Services
Data Quality Services is a SQL Server component that provides tools for defining, managing, and improving the quality and consistency of data through knowledge-based cleansing and matching.
-
B.
Data & Analytic Services
Data & Analytic Services is a business segment of Aon Corporation that focuses on providing data-driven insights, analytics, and related solutions to support risk management and decision-making for clients.
-
C.
Data Services Department
The Data Services Department is a specialized unit within the OPEC Secretariat responsible for collecting, managing, and analyzing energy and oil market data to support the organization’s research and policy decisions.
-
D.
Data
Data is an android Starfleet officer in Star Trek: The Next Generation, known for his quest to understand humanity and develop emotions.
-
E.
Azure Data Factory
Azure Data Factory is a cloud-based data integration service from Microsoft that enables users to create, schedule, and orchestrate data pipelines for moving and transforming data at scale across diverse sources.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Data Transformation Services Target entity description: Data Transformation Services (DTS) was an early Microsoft SQL Server component used to extract, transform, and load (ETL) data between heterogeneous data sources before being superseded by SQL Server Integration Services.
-
A.
Data Quality Services
Data Quality Services is a SQL Server component that provides tools for defining, managing, and improving the quality and consistency of data through knowledge-based cleansing and matching.
-
B.
Data & Analytic Services
Data & Analytic Services is a business segment of Aon Corporation that focuses on providing data-driven insights, analytics, and related solutions to support risk management and decision-making for clients.
-
C.
Data Services Department
The Data Services Department is a specialized unit within the OPEC Secretariat responsible for collecting, managing, and analyzing energy and oil market data to support the organization’s research and policy decisions.
-
D.
Data
Data is an android Starfleet officer in Star Trek: The Next Generation, known for his quest to understand humanity and develop emotions.
-
E.
Azure Data Factory
Azure Data Factory is a cloud-based data integration service from Microsoft that enables users to create, schedule, and orchestrate data pipelines for moving and transforming data at scale across diverse sources.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
ETL tool
ⓘ
Microsoft SQL Server component ⓘ data integration tool ⓘ |
| abbreviation | DTS ⓘ |
| allows |
conditional workflow branching
ⓘ
event-driven task execution ⓘ graphical design of data workflows ⓘ |
| availableInVersion |
SQL Server 2000
ⓘ
linked to:
SQL Server
SQL Server 7.0 ⓘ
linked to:
SQL Server
|
| canBeExtendedWith | custom COM components ⓘ |
| category |
business intelligence technology
ⓘ
data warehousing technology ⓘ |
| configurationInterface |
SQL Server Enterprise Manager
ⓘ
linked to:
SQL Server Management Studio
|
| designedFor | heterogeneous data sources ⓘ |
| developer | Microsoft ⓘ |
| executionMethod |
executed on demand
ⓘ
scheduled via SQL Server Agent ⓘ |
| hasComponent |
DTS Designer
ⓘ
linked to:
SQL Server Integration Services
DTS Import Export Wizard ⓘ DTS Package ⓘ DTS Runtime ⓘ |
| languageSupport |
JScript
ⓘ
VBScript ⓘ |
| partOf |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| platform |
Microsoft Windows
ⓘ
linked to:
Windows
|
| primaryFunction |
extract data
ⓘ
load data ⓘ transform data ⓘ |
| releaseStatus | deprecated ⓘ |
| replacedBy | SQL Server Integration Services ⓘ |
| supersededInVersion |
SQL Server 2005
ⓘ
linked to:
SQL Server
|
| supports |
ActiveX scripting
ⓘ
ETL workflows ⓘ Microsoft Excel data sources ⓘ Microsoft SQL Server data sources ⓘ ODBC data sources ⓘ OLE DB data sources ⓘ Visual Basic scripting ⓘ data export ⓘ data import ⓘ data migration ⓘ error handling in packages ⓘ logging of package execution ⓘ scheduling of packages ⓘ text file data sources ⓘ |
| typicalUseCase |
data consolidation
ⓘ
data transformation between heterogeneous systems ⓘ data warehouse loading ⓘ |
| uses | DTS packages to define workflows ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Data Transformation Services Description of subject: Data Transformation Services (DTS) was an early Microsoft SQL Server component used to extract, transform, and load (ETL) data between heterogeneous data sources before being superseded by SQL Server Integration Services.
Referenced by (4)
Full triples — surface form annotated when it differs from this entity's canonical label.