SQL Server 2k DTS Import/export wiz failure

[sunshine9]

Hello,

I'm creating a doc for end-users to export data from my db into an archive. I thought the easiest way would be for them to use the DTS import/export wizard. I have them export the data into a flat file (.csv) and then when needed, import this file using the wizard again.

However, when the file is large (~700MB) or greater, the import fails. this has happened repeatedly. the error is:
Row XXXX: column delimiter not found.

so the whole import fails and that data is now "lost".

does anyone know of any size limitations with the wizard? I have to make this archival process as 'simple' as possible and am afraid to mandate the use of BCP. The wiz is easy but just doesnt work nicely.

any thoughts?

thanks,