DTS Runtime
E1007513
DTS Runtime is the execution engine within SQL Server’s Data Transformation Services that runs and manages data transformation and ETL packages.
Statements (47)
| Predicate | Object |
|---|---|
| instanceOf |
execution engine
ⓘ
software component ⓘ |
| accessibleFrom |
ActiveX scripting
NERFINISHED
ⓘ
VBScript NERFINISHED ⓘ Visual Basic 6 NERFINISHED ⓘ |
| category |
ETL engine
ⓘ
data integration technology ⓘ |
| configuration |
connection properties
ⓘ
package properties ⓘ task properties ⓘ |
| controls |
DTS connections
ⓘ
DTS global variables ⓘ DTS steps ⓘ DTS tasks ⓘ |
| developer | Microsoft ⓘ |
| executes |
DTS packages stored in Meta Data Services
ⓘ
DTS packages stored in SQL Server ⓘ DTS packages stored in structured storage files ⓘ |
| exposes | COM interfaces ⓘ |
| introducedIn | late 1990s ⓘ |
| language | COM automation ⓘ |
| manages |
DTS package execution
ⓘ
error handling ⓘ logging ⓘ task scheduling ⓘ workflow control ⓘ |
| operatesOn | DTS packages ⓘ |
| partOf |
Data Transformation Services
NERFINISHED
ⓘ
Microsoft SQL Server NERFINISHED ⓘ |
| predecessorOf | SSIS runtime ⓘ |
| provides |
event notifications
ⓘ
programmatic control of DTS packages ⓘ transaction support ⓘ |
| relatedTo | DTS Designer NERFINISHED ⓘ |
| replacedBy | SQL Server Integration Services runtime NERFINISHED ⓘ |
| runsOn | Windows operating system NERFINISHED ⓘ |
| supports |
package-level transactions
ⓘ
step-level transactions ⓘ |
| supportsFunction |
ETL processing
ⓘ
data extraction ⓘ data loading ⓘ data transformation ⓘ |
| usedFor |
data consolidation
ⓘ
data migration ⓘ data warehousing ⓘ |
| usedIn |
SQL Server 2000
NERFINISHED
ⓘ
SQL Server 7.0 NERFINISHED ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.