Using the Wizard
SQL Server is a feature rich product and can be quite daunting. Luckily for us though Microsoft has provided us with some wizards that can help us climb the learning curve. One of those wizards is for DTS and we'll use
that to import our text file. When there are options that need to be explained we'll do it. By the time we get to the end we'll have covered al the bases in as much detail as we can
We are going to import the text file into the Pubs database so to get the wizard started we need to right click on the database, select All Tasks then choose Import Data . Figure 1-1 shows the resulting screen
Figure 1.1 Starting the Wizard.