Reply
New Contributor
Posts: 3
Registered: ‎02-01-2019

ODBC error in SSIS

Impala ODBC 2.6.0

I have a simple etl package set up to import data into an impala table

ImpalaODBCErr2.png

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.

 

ImpalaODBCerr.png

Please help. What am I missing?

New Contributor
Posts: 3
Registered: ‎02-01-2019

Re: ODBC error in SSIS

[ Edited ]

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. 

New Contributor
Posts: 3
Registered: ‎02-01-2019

Re: ODBC error in SSIS

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.

Announcements