Database Reference
In-Depth Information
The package should run successfully, transfer records from the Hive table to the SQL Server table, and display the
total number of records imported, as shown in Figure
10-20
.
Figure 10-20.
Successful package execution
If you are running this package in a 64-bit Windows operating system, you need to change the
Run64BitRuntime
property to
False
. This can be done from the Project Properties
➤
Configuration Properties
➤
Debugging tab to
execute the package as it is using the 32-bit Hive ODBC driver, as shown in Figure
10-21
.
