How can I have no column delimiter in a text output file?

[statcan]

I am running a "select * from table" task in a DTS package and then converting the data into a text file. But I do not want any column delimiter in the text file. The only options I seem to have are comma, vertical bar, semicolon and one other thing. How do I ask for no delimiter??

Thanks in advance for your answers

 

[NathanGriffiths]

If you don't want delimiters in your output text file, you can choose the "Fixed field" option instead of "Delimited".

This will output the data aligned into columns of equal width, without delimiters.

Nathan