Figure 1.8 Choose Column Delimiter.

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