General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Inserting into FoxPro table from DTS
Environment versions
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only