Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ODBC error in SSIS

ODBC error in SSIS

New Contributor

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?

2 REPLIES 2

Re: ODBC error in SSIS

New Contributor

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. 

Highlighted

Re: ODBC error in SSIS

New Contributor

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.