• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

The DTS Wizard

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.

More Information

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 tasks.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint