Kbase P21992: Using Microsoft DTS package to copy data from SQL Server to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/26/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3x
FACT(s) (Environment):
MERANT 3.70 32-BIT Progress SQL-89
SYMPTOM(s):
Using Microsoft DTS package to copy data from SQL Server to Progress database fails
The number of failing rows exceeds the maximum specified.
[MERANT][ODBC PROGRESS driver]Function sequence error.
The trace in the ODBC SQL log file shows this:
- SQLPrepareW "INSERT INTO Customer (CustNum,Country etc.) VALUES (?,? etc.)"
- SQLBindParameter is called for each column/field
- SQLExecute returns SQL_SUCCESS (First record inserted)
- SQLBindParameter is called for each column/field for the subsequent row (second)
- SQLExecute returns SQL_ERROR
Only one record is created in the Progress database whereas there should be more.
Number of records is not relevant - having only two records in the
table produces the same error
CAUSE:
The problem in the way how MERANT ODBC handles calls from MS DTS package.
FIX:
Use third party ODBC driver from OpenLink that doesn't exhibit the problem
with Microsoft DTS package execution.