Importing/Exporting Data  «Prev 

SQL-Server DTS Wizard

1) The DTS Wizard startup screen displays generic information about the DTS Wizard.

2) After viewing the initial startup screen, you go to the DTS Wizard Choose a Data Source Screen. This screen allows you to select a data source. Depending on the data source you choose, you will have different source options.

3) This is the Data Destination Screen. You can select any data destination that your computer is configured to talk to. For each data destination type you can enter all of the information needed to connect to it.

4) The next step in transforming data is to specify if you are going to copy a table, use a query, or move data between SQL Servers. When copying data you can copy the tables, recreating tables on the destination server.