Importing Azure Blob storage data

So far, we've created and dropped a HDInsight cluster and called a Pig script using the Azure Pig task. This recipe will demonstrate how to import data from an Azure Blob storage to a table in the staging schema.

Getting ready

This recipe assumes that you have completed the previous one.

How to do it...

1. From the SSIS toolbox, drag and drop, and Execute SQL Task on the control flow, and rename it sql_truncate_Staging_StgCloudSales.
2. Double-click on it to open the SQL Task Editor. Set the properties as follows and click on OK:
   • Connection...