Azure-Enabled SSIS Projects

The Azure-SSIS Team recently released an update to the Integration Services Extension. The update includes a new project template named “Integration Services Project (Azure-Enabled)”. The functionality is driven by another recent addition to Azure-SSIS; the ability to execute SSIS packages from Azure File Shares. I refer to this as “Azure-SSIS (Files)”. I’ve written and presented about executing SSIS packages from Azure File Shares in Azure-SSIS:

Demo

I believe folks learn best by doing. For this example, I start after adding the Integration Services extension (version 3.1+) to Visual Studio 2019, which I describe in a post titled SSIS in Visual Studio 2019. I begin creating a new project and search for “Integration” in templates. I select “Integration Services Project (Azure-Enabled)”:

I next configure the new project:

After creating the new project, I notice some differences in Solution Explorer. The “Linked Azure Resources” node is new. Right-click the “Linked Azure Resources” virtual folder and click “Connect to SSIS in Azure Data Factory”:

Clicking the “Connect to SSIS in Azure Data Factory” menu item fires up the “SSIS in ADF Connection Wizard”:

The “SSIS in ADF Connection Wizard” shares some functionality with the “Integration Runtime Creation Wizard” I mentioned in SSIS in SSMS Version 18: Try SSIS in Azure Data Factory.

The next step in the wizard is to select the Azure-SSIS Integration Runtime you wish to use with this SSIS project. Note you may only configure Azure-SSIS Integration Runtimes that do not use the SSIS Catalog (SSISDB) – Azure-SSIS (Files) IR’s only:

After selecting the Azure-SSIS (Files) Integration Runtime, configure the location of the Azure Files in Azure Storage:

The configured Azure-SSIS resources are now visible in Solution Explorer:

Executing the SSIS Package in Azure-SSIS (Files)

To execute the SSIS package in Azure-SSIS, right-click the package in Solution Explorer and click “Execute Package in Azure”, or click the Start dropdown and click “Execute in Azure”:

A couple things to note regarding execution:

  1. The Progress tab displays and reports “The package is executing. Waiting to fetch result…”
  2. The Visual Studio status displays “This item does not support previewing”:

Package execution completes (successfully!):

Conclusion

It’s pretty cool to be able to execute from Visual Studio and have the SSIS package run in Azure-SSIS (Files). Kudos to the Azure-SSIS Team for surfacing this functionality!

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, SSIS and Biml guy. I was cloud before cloud was cool. :{>

One thought on “Azure-Enabled SSIS Projects

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.