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.