To start the DTS Import/Export Wizard, select Start, then Microsoft SQL Server, then Import and Export Data, which activates the DTS Import/Export Wizard, click next, and the Choose A Data Source wizard screen appears, as shown in Figure 22-1. This is where you determine the data source by using the Source combo box to choose the required OLE DB, ODBC, or Indexed Sequential Access Method (ISAM) driver. Depending on the source chosen, the corresponding fields in that group are displayed. The following example uses the ContosoSQL database on the local server.
The DTS Import/Export Wizard can be activated through various context menus within the SQL Server Enterprise Manager console as Import Data or Export Data ...