Many thanks - I'll give it a try

Many thanks for your prompt response and workaround to the issue.

I am slightly amazed that SSIS does not have a capability built into this. I used to run DTS packages...

It was ...

Error at ..The data type for [column] is DT_Ntext, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_Ntext using the data...

Many thanks for your response but that is for the column delimiter, not the 'text delimiter'.

You can set the text delimiter when you export text and it will give...

Thanks for your response. This is the first occassion that I have seen the dumps so I am not sure if this will be a continuing issue.

I will keep my...