Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Inserting into FoxPro table from DTS
Versions des environnements
Network:
Windows 2000 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement