Database Reference
In-Depth Information
Figure 10-14.
Hive table columns
Creating the SQL Destination Component
After the source is configured, you need to configure the destination where you want to import the Hive data.
In this example, I use SQL Server as the destination. To do this, double-click on
OLE DB Destination
component in the
Toolbox, and place an
OLE DB Destination
component on the
Data Flow
canvas. Make sure you connect the
ADO.
NET source
and the
OLE DB Destination
components by dragging the arrow between the source and the destination.
This is required for SSIS to generate the metadata and the column mappings for the destination automatically based
on the source schema structure. The package should look something like Figure
10-15
.