Azure Feature Pack

SQL Server Integration Services (SSIS) Feature Pack for Azure is an extension that provides the components listed on this page for SSIS to connect to Azure services, transfer data between Azure and on-premises data sources, and process data stored in Azure.

Components in the Feature Pack

• Connection Managers

  • Azure Storage Connection Manager

  • Azure Subscription Connection Manager

  • Azure Data Lake Store Connection Manager

  • Azure Resource Manager Connection Manager

  • Azure HDInsight Connection Manager

• Tasks

  • Azure Blob Upload Task

  • Azure Blob Download Task

  • Azure HDInsight Hive Task

  • Azure HDInsight Pig Task

  • Azure HDInsight Create Cluster Task

  • Azure HDInsight Delete Cluster Task

  • Azure SQL DW Upload Task

  • Azure Data Lake Store File System Task

• Data Flow Components

  • Azure Blob Source

  • Azure Blob Destination

  • Azure Data Lake Store Source

  • Azure Data Lake Store Destination

• Azure Blob Enumerator & ADLS File Enumerator. See Foreach Loop Container.

Download the Feature Pack

Download the SQL Server Integration Services (SSIS) Feature Pack for Azure.

• Microsoft SQL Server 2014 Integration Services Feature Pack for Azure

Prerequisites

You must install the following prerequisites before installing this feature pack.

• SQL Server Integration Services
• .Net Framework 4.5

Scenarios

Big Data Processing

Use Azure Connector to complete following big data processing work:

1. Use the Azure Blob Upload Task to upload input data to Azure Blob Storage.

2. Use the Azure HDInsight Create Cluster Task to create an Azure HDInsight cluster. This step is optional if you want to use your own cluster.

3. Use the Azure HDInsight Hive Task or Azure HDInsight Pig Task to invoke a Pig or Hive job on the Azure HDInsight cluster.

4. Use the Azure HDInsight Delete Cluster Task to delete the HDInsight Cluster after use if you have created an on-demand HDInsight cluster in step #2.

5. Use the Azure HDInsight Blob Download Task to download the Pig/Hive output data from the Azure Blob Storage.

Cloud Data Archiving

Use the Azure Blob Destination in an SSIS package to write output data to an Azure Blob Storage, or use the Azure Blob Source to read data from an Azure Blob Storage.

And use the Foreach Loop Container with Azure Blob Enumerator to process data in multiple bob files.