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

Figure 1.6 Column Delimiters

Column Delimiters

This screen again requires some looking at. There is a large window which shows our data and above that are the choices for our column delimiters The only one that needs further clarification is the final one other. An example of how you might use this is if your data is pipe delimited or any other delimiter which is not one explicitly mentioned here. When you choose the correct delimiter you'll see that the data underneath seperate nicely into the respective columns.

Click Next