DTS Import Export Wizard
E1007514
DTS Import Export Wizard is a graphical tool in SQL Server’s Data Transformation Services that guides users through copying, importing, and exporting data between different sources and destinations.
Statements (47)
| Predicate | Object |
|---|---|
| instanceOf |
data export tool
ⓘ
data import tool ⓘ data migration tool ⓘ graphical user interface ⓘ software tool ⓘ |
| allows |
definition of simple transformations
ⓘ
filtering of rows during transfer ⓘ selection of tables and views for transfer ⓘ |
| category |
ETL tool
ⓘ
database administration tool ⓘ |
| configurationMethod |
dialog boxes
ⓘ
wizard pages ⓘ |
| deprecatedIn | SQL Server 2005 era ⓘ |
| developedBy | Microsoft ⓘ |
| hasPurpose |
copy data between data sources
ⓘ
export data from SQL Server ⓘ import data into SQL Server ⓘ transform data during transfer ⓘ |
| inputFormat |
Microsoft Excel files
ⓘ
OLE DB data sources ⓘ relational databases ⓘ text files ⓘ |
| introducedIn | late 1990s ⓘ |
| output | DTS package ⓘ |
| outputFormat |
Microsoft Excel files
ⓘ
OLE DB data destinations ⓘ SQL Server databases ⓘ relational databases ⓘ text files ⓘ |
| partOf |
Microsoft SQL Server
NERFINISHED
ⓘ
SQL Server Data Transformation Services NERFINISHED ⓘ |
| relatedTo |
DTS Designer
NERFINISHED
ⓘ
DTS runtime NERFINISHED ⓘ |
| replacedBy | SQL Server Import and Export Wizard NERFINISHED ⓘ |
| runsOn | Microsoft Windows NERFINISHED ⓘ |
| status | deprecated ⓘ |
| succeededBy | SQL Server Integration Services Import and Export Wizard NERFINISHED ⓘ |
| supportsFeature |
basic data transformations
ⓘ
column mapping between source and destination ⓘ executing DTS packages immediately ⓘ graphical configuration of data transfers ⓘ saving DTS packages ⓘ scheduling DTS packages via SQL Server Agent ⓘ selection of source and destination connections ⓘ step-by-step wizard interface ⓘ |
| usedWith |
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.