I want to extract data from a DataFlex table using FlexODBC 4 and store it in a MS SQL Server 2000 table. I am using a Transform Data Task for this and the query looks like this (simplified):
select BRANCH_NO, AUTO_SEQ_NO, OMZET from STAT_TOT where (MOD_DATE > ?)
When I let the software parse the query it tells me it's ok, but when I want to set up the parameters it tells me "The SQL statement does not contain any parameters".
Somehow FlexODBC does not report the necessary parameters... |