Hi,

We have created an application which processes large amounts of data (3GB+) and need to export these data sets to text files.

We have used SQL DTS to achieve this, but are finding significant problems with date formatting (cannot get rid of timestamp) & truncation of data (over 255 characters) are causing us problems. I have looked for fixes but none of them are easily achievable at the moment.

Does anyone know of any decent 3rd party applications which can achieve this, or know of any workarounds to get past these issues?

Thanks.