I have an SSIS package that brings data from Impala database and loads into SQL server - gateway I'm using here ODBC-32 bit. The issue here is after SSIS package getting 1M rows it is failing. The error message that I get from the package are below
1)[ODBC Source ] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY000'. Native Error Code: 120. [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [HY000] : Invalid query handle:
2)[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput().
But, when I check the ODBC logs this is the error message: ERROR::SQLGetInfoW: [Cloudera][ODBC] (11180) SQLGetInfo property not found.
Any suggestions or help on this issue?
... View more