Microsoft has released SSIS Feature pack for Azure that allows us to connect with Azure, transfer data between azure and on-premises data sources, and most importantly process data using HDInsight. It release includes following components;
Connection Managers
Tasks
Data Flow Components
Azure Blob Enumerator
Connection Managers
- Azure Storage Account Connection Manager
- Azure Subscription 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
Data Flow Components
- Azure Blob Source
- Azure Blob Destination
Azure Blob Enumerator
- for Foreach Loop Container
Download the feature pack for SQL Server 2012 from here: https://www.microsoft.com/en-us/download/details.aspx?id=47367
Download the feature pack for SQL Server 2014 from here: https://www.microsoft.com/en-us/download/details.aspx?id=47366
Once it is installed, items should be appeared as below images;
Control Flow Items:
Data Flow Items:
No comments:
Post a Comment