Integrating HDInsight with SQL Server Integration Services - Pro Microsoft HDInsight: Hadoop on Windows - page 175

Figure 10-15. Creating the OLE DB destination

■ In this example, I used the oLe DB Destination component to bind to the target sQL server table. however, you
also can use the aDo .net Destination or sQL server Destination components for the same purpose. however, be aware
that sQL server Destination works only if the package runs locally on the same system where sQL server resides.

Note

Now, it is time to configure the OLE DB Destination component to point to the correct SQL connection and
database table. To do this, right-click the OLE DB Destination component and select Edit . Select the OLE DB
connection manager to SQL that you just created and the target table. In this case, I named the connection SQL
Connection and predefined a table created in the SQL database called stock_analysis . If you don't have the table
precreated, you can choose to create the destination table on the fly by clicking the New button adjacent to the name
of the table or the view drop-down list. This is illustrated in Figure 10-16 .