Justin,

You do not need a third party solution for this. Create a view of the data you want and use the CAST or CONVERT functions to trim and edit the datetime and character fields you need edited to be in the form you need. Just check the documentatio for the use of these functions. Then use DTS to export the view.

HTH

>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.