DTS Import Export Wizard

E1007514

data export tool data import tool data migration tool graphical user interface software tool

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.

Try in SPARQL Jump to: Surface forms Disambiguation Statements Elicitation Referenced by

All labels observed (3)

Label	Occurrences
DTS Designer	1
DTS Import Export Wizard canonical	1
SQL Server Import and Export Wizard	1

How this entity was disambiguated

This entity first appeared as the object of triple T12873175 — 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: DTS Import Export Wizard
Context triple: [Data Transformation Services, hasComponent, DTS Import Export Wizard]

A. IDERA Database Tools
IDERA Database Tools is a suite of database management and monitoring solutions designed to help administrators ensure performance, security, and reliability across diverse database environments.
B. ETL
ETL is the three-letter National Rail station code for East Tilbury railway station in Essex, England.
C. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
D. VSS Enterprise
VSS Enterprise was the first SpaceShipTwo suborbital spaceplane built by Virgin Galactic for commercial space tourism test flights.
E. dta.exe
dta.exe is the command-line version of SQL Server's Database Tuning Advisor, used to analyze workloads and recommend indexing and partitioning strategies for performance optimization.
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: DTS Import Export Wizard
Target entity description: 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.

A. IDERA Database Tools
IDERA Database Tools is a suite of database management and monitoring solutions designed to help administrators ensure performance, security, and reliability across diverse database environments.
B. ETL
ETL is the three-letter National Rail station code for East Tilbury railway station in Essex, England.
C. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
D. VSS Enterprise
VSS Enterprise was the first SpaceShipTwo suborbital spaceplane built by Virgin Galactic for commercial space tourism test flights.
E. dta.exe
dta.exe is the command-line version of SQL Server's Database Tuning Advisor, used to analyze workloads and recommend indexing and partitioning strategies for performance optimization.
F. None of above. chosen

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 ⓘ linked to: SQL Server SQL Server Data Transformation Services ⓘ linked to: SQL Server Integration Services
relatedTo	DTS Designer ⓘ linked to: DTS Runtime DTS runtime ⓘ linked to: DTS Runtime
replacedBy	SQL Server Import and Export Wizard ⓘ linked to: DTS Import Export Wizard
runsOn	Microsoft Windows ⓘ linked to: Windows
status	deprecated ⓘ
succeededBy	SQL Server Integration Services Import and Export Wizard ⓘ linked to: SQL Server Integration Services
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 ⓘ linked to: SQL Server SQL Server 7.0 ⓘ linked to: SQL Server

How these facts were elicited

Referenced by (3)

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

Data Transformation Services → hasComponent → DTS Import Export Wizard ⓘ

DTS Runtime → relatedTo → DTS Designer ⓘ

linked to: DTS Import Export Wizard

DTS Import Export Wizard → replacedBy → SQL Server Import and Export Wizard ⓘ