I have a large SQL 2000 database that I am attempting to export, in chunks, into VFP 7.0 databases using a DTS package.

Everything works fine except fields defined as SQL text, and mapped to Memo fields in my existing vfp database are not being translated. In testing this I found that the Data Transformation is receiving an error - "Data for source column(n) is too large for the specified buffer size.

I've researched this fairly well ( I think ) and have attempted the following.

1) Adjusting registry entries that indicate how many rows to check for field size.

2) Ordered source table by Datalength(fieldname) that was causing problems.

Still have same issues.

Any help will be GREATLY appreciated.