Effective Big Data ETL with SSIS, Pig, and Sqoop - Microsoft Big Data Solutions - page 192

NOTE
In different SSIS versions, you work with Hive in different ways. SSIS
2008 R2 and earlier support ODBC through an ADO.NET wrapper,
whereas SSIS 2012 and later let you access ODBC directly. Generally,
direct access results in better performance, so 2012 is recommended for
use with Hive, but it's not required.
Another difference between SSIS 2008 R2 and 2012 is that the
development environment has changed names. In 2008 R2 and earlier,
it is known as Business Intelligence Developer Studio (BIDS). In 2012
and later, it is named SQL Server Data Tools - Business Intelligence
(SSDT-BI). It works essentially the same in both versions, so
instructions provided for one will apply to the other, unless specifically
noted otherwise.
Configuring a Connection Manager for Hive
To extract data from Hive, you can set up an ODBC connection to the Hive
database, using the connection string created in the section “Connecting to
Hive.” The first step in this process is creating a package and setting up a
connection manager. If you are using SSIS 2008 R2 or earlier versions, you
must use an ADO.NET connection manager to use the ODBC driver:
1. To create a package, choose New Connection from the SSIS menu in
Business Intelligence Developer Studio (BIDS).
2. Choose the ADO.NET item from the list.
3. In the resulting screen, make sure that you change the Provider option
at the top of the screen to .NET Providers\ODBC Data Provider. This
uses the ODBC provider through an ADO.NET wrapper.
4. After you have selected the ODBC Data Provider, you can provide either
the DSN or input the connection string you created in the section
“Connecting to Hive.”