Database Reference
In-Depth Information
The pre-requisites to developing the package shown in this chapter are SQL Server Data Tools (which comes
as a part of SQL Server 2012 Client Tools and Components) and the 32-Bit Hive ODBC Driver installed. You will also
need either an on-premise HDInsight Emulator or a subscription for the Windows Azure HDInsight Service with Hive
running on it. These details were discussed previously Chapters 2 and 3.
Creating the Project
SQL Server Data Tools (SSDT) is the integrated development environment available from Microsoft to design, deploy,
and develop SSIS packages. SSDT is installed when you choose to install SQL Server Client tools and Workstation
Components from your SQL Server installation media. SSDT supports the creation of Integration Services, Analysis
Services, and Reporting Services projects. Here, the focus is on the Integration Services project type.
To begin designing the package, load SQL Server Data Tools from the SQL Server 2012 program folders as
in Figure 10-1 .
Figure 10-1. SQL Server data tools
Create a new project, and choose Integration Services Project in the New Project dialog as shown in Figure 10-2 .
 
Search WWH ::




Custom Search