Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Building a Package in the DTS Designer
By Allan Mitchell
Version 7.0/2000
Level Beginner

Figure 1.8 Choose Column Delimiter.

Text coldelimit

We have a choice on this screeen as to what delimits the columns in our text file. DTS offers us some standards like comma and semicolon but right at the end we get to choose our own if we need to. The thing about delimiters is that ideally you need to use one that is not found in your actual data. A comma is often found in denormalised addresses so can be problematic (Not impossible just we need think about it more). One of the delimiters we like is the pipe or vertical bar.

Our data is comma delimited so we leave it selected. Click on Finish