I am trying to data transform task to copy data from a SQL Server 2000 table to a Progress 8.3E database table. I am connecting to the Progress database using the Merant DataDirect Technologies ODBC drivers v3.7.
When I run the DTS job I get the error:
[MERANT][ODBC PROGRESS driver]Function sequence error.
I turned on logging in the data transform task and I found the following error for every other record: (2, 4, 6, 8...)
Error at Destination for Row number 2. Errors encountered so far in this task: 1.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:[MERANT][ODBC PROGRESS driver]Function sequence error.
Error Help File:
Error Help Context ID:0
@@DestRow: Logging Failed
Error code: 8007000E
I have tried turning off fast load, using another computer, changing lock options, with no luck.