DTS

E1007512

DTS is a legacy Microsoft SQL Server toolset used to design, execute, and manage data extraction, transformation, and loading (ETL) workflows.

All labels observed (2)

Label Occurrences
DTS canonical 1
DTS Packages 1

How this entity was disambiguated

Statements (46)

Predicate Object
instanceOf ETL tool ⓘ
Microsoft SQL Server component ⓘ
data transformation toolset ⓘ
legacy software ⓘ
abbreviationOf Data Transformation Services ⓘ
availableInVersion SQL Server 2000 ⓘ
linked to: SQL Server

SQL Server 7.0 ⓘ
linked to: SQL Server
canExecuteFrom SQL Server Enterprise Manager ⓘ
command line ⓘ
scheduled SQL Server Agent jobs ⓘ
category data integration software ⓘ
database tooling ⓘ
deploymentModel server-based ⓘ
developer Microsoft ⓘ
executionModel package-based ⓘ
fullName Data Transformation Services ⓘ
hasComponent DTS Designer ⓘ
DTS Packages ⓘ
linked to: DTS

DTS Runtime ⓘ
hasInterface Enterprise Manager integration ⓘ
graphical package designer ⓘ
introducedInVersion SQL Server 7.0 ⓘ
linked to: SQL Server
partOf Microsoft SQL Server ⓘ
linked to: SQL Server
primaryPlatform Windows ⓘ
relatedTo Microsoft SQL Server Agent ⓘ
linked to: SQL Server Agent

SQL Server Integration Services ⓘ
status deprecated ⓘ
succeededBy SQL Server Integration Services ⓘ
supportsDestination OLE DB data destinations ⓘ
SQL Server databases ⓘ
supportsFeature ActiveX scripting ⓘ
linked to: ActiveX

error handling ⓘ
logging ⓘ
workflow precedence constraints ⓘ
supportsSource OLE DB data sources ⓘ
relational databases ⓘ
text files ⓘ
supportsTask data cleansing ⓘ
data export ⓘ
data import ⓘ
data migration ⓘ
workflow automation ⓘ
usedFor ETL workflows ⓘ
data extraction ⓘ
data loading ⓘ
data transformation ⓘ

How these facts were elicited

Referenced by (2)

Full triples — surface form annotated when it differs from this entity's canonical label.

DTS → hasComponent → DTS Packages ⓘ
linked to: DTS