Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Importing A Text File Using The DTS Wizard
By Allan Mitchell
Version 7.0/2000
Level Beginner

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.

Starting The Wizard