Impala ODBC 2.6.0
I have a simple etl package set up to import data into an impala table
I am able to test odbc connection successfully. I am able to create and test the new connection manager in SSIS.
When I attemp to select a table from the drop down list or type in manually I get the following.
Please help. What am I missing?
As I dig into this I realize that issue is the version of the ODBC connector and the version of VS and SSDT (Currently 2013).
When I attempt to use the ODBC connector in VS2017, it works locally. Now to get it to work when deploying via project deployment model to SSISDB.
I can setup the package now, it recognizes the table, that I created in impala and the columns. But when I attemp to run it, I get an error. So still more to do on this.