>Hi,
>
>Not sure if this is a FoxPro or SQL DTS question.
>
>We've created a DTS Package which extracts from SQL 2000 OK, then trying to Insert into the a FoxPro table with a memo field is failing. If the memo field is not included on the Insert then it fails, because the memo field does not allow nulls (and the table cannot be changed to accept Nulls (not our table)). If the field is defined on the INSERT & either of these values are used 'XXXXX' or '' or ' ', the following msg appears in the DTS Error log:
>
>Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft OLE DB Provider for ODBC Drivers (80004005): Query-based insertion or updating of BLOB values is not supported.)
>
>
>Any help would be appreciated..
>
>Joe M
Edit your DTS package to use VFPOLEDB driver instead and add "set null off" command before other commands.
Cetin