I would like to use 'any character' plus a '\n' as a row
delimiter when exporting a table to a text file. Problem is, DTS does
not seem to allow a delimeter such as '||\n' as a row delimiter. I
would like to modify the DTS defaults such as the '{CR}{LF}'. Have
tried combinations such as '||{CR}{LF}'...'{||}{CR}{LF}'..ect... When
these are used, the actual row delimiters ends up being exactly what
was typed '||{CR}{LF}' not as what is expected. '||' (and then a \n)

Does anyone know how do I go about inserting 'any character' + '\n'
into the Select Destination File Format screen in the DTS Export
wizard?

thanks,
Todd

In article <d6f75380.0308191053.d469c50 (AT) posting (DOT) google.com>, tmw
<todd (AT) jr (DOT) com> writes
You can use Disconnected Edit or and ActiveX Script Task to get around
the limitations of the UI. Whilst you can type any character into the
UI, you have to be able to type it!

This covers a similar issue-

Coping with text files and abnormal column or row delimiters
http://www.sqldts.com/default.aspx?6,101,257,0,1
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com