New Azure Feature Pack Release with Data Lake Analytics Task & Enhanced SQL DW Upload Task

This post has been republished via RSS; it originally appeared at: SQL Server Integration Services (SSIS) articles.

First published on MSDN on Jul 10, 2018
Dear Customers,

We are happy to announce that we have released a new version of SSIS Azure Feature Pack with a brand-new Azure Data Lake Analytics Task and enhanced Azure SQL DW Upload Task .

1. Azure Data Lake Analytics Task: Azure Data Lake Analytics is an on-demand analytics job service that simplifies big data. Instead of deploying, configuring, and tuning hardware, you write queries directly to transform your data and extract valuable insights. The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need. You only pay for your job when it is running, making it cost-effective. Through Azure Data Lake Analytics Task in SSIS Azure Feature Pack, you can now orchestrate Azure Data Lake Analytics U-SQL jobs as part of SSIS workflow to process big data on cloud.


2. Azure SQL DW Upload Task: While the original task only supported copying from local file system, using Azure Blob Storage for staging, the new one now supports copying directly from Azure Blob Storage.

You can download this new version of Azure Feature Pack from the following links:

• Azure Feature Pack for SQL Server 2012


• Azure Feature Pack for SQL Server 2014


• Azure Feature Pack for SQL Server 2016


• Azure Feature Pack for SQL Server 2017