ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am setting up Visual Importer ETL to import delimted test files into a progress database table through an odbc connection. I get inconsistent results in testing. It may import the first row then fail the rest. Best way to troubleshoot this?

Error 05/04/2011 9:44:55 AM Record:2 Line:3 HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 11 has changed since first SQLExecute call.
Error 05/04/2011 9:44:55 AM Record:3 Line:4 HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 11 has changed since first SQLExecute call.
Error 05/04/2011 9:44:55 AM Record:4 Line:5 HY000 [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Data type for parameter 10 has changed since first SQLExecute call.
Information 05/04/2011 9:44:55 AM Processed : 1 Record(s)
Information 05/04/2011 9:44:55 AM Records per second : 129.03
Information 05/04/2011 9:44:55 AM Rejected : 3 Record(s)
Information 05/04/2011 9:44:55 AM Inserted : 1 Record(s)
Information 05/04/2011 9:44:55 AM Updated : 0 Record(s)
Information 05/04/2011 9:44:55 AM Deleted : 0 Record(s)
Information 05/04/2011 9:44:55 AM Filtered : 0 Record(s)
Information 05/04/2011 9:44:55 AM Transformation is finished

Thanks,
Joe

Can you try adding WorkArounds=536870912 to your data source. You can read more about how to use WorkArounds in the ODBC readme. From the readme:

WorkArounds=536870912. This option allows for re-binding parameters after calling SQLExecute for prepared statements.

Please let us know the outcome,
Mike

Mike,

I applied the workaround to the target odbc data source in registry and problem solved.

Thanks.