Support Questions
Find answers, ask questions, and share your expertise

Impala ODBC SSIS: Overlapping Asynchronous SQL Task Error

Impala ODBC SSIS: Overlapping Asynchronous SQL Task Error

New Contributor

I was trying to develop sequential SQL Task. The flow is Drop Table A, Create Table A (Refresh new data with Create table as select) and then Drop Table B, Create Table B with reference from table A (Create Table As Select .... from B). The problem is when task running, table not found error happen. I think it's because ODBC asyncexecpollinterval setting in ODBC, so the task is run asycnhronously. When i increase the interval the task seems good. Anybody ever face the error like this? or is there any option to turn off asynchrounous execution in Impala ODBC?