<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

SSIS in the Cloud Overview

SSIS in the Cloud Overview


Do you want to learn how to manage and execute SSIS inside of Azure using “Lift and Shift”? In a recent webinar, Manuel Quintana, discussed some of the potential issues you could encounter and how it compares to Azure Data Factory.

You may be thinking about SSIS in the cloud and that could mean different things such as:

  • Running SSIS packages that move data to/from cloud sources
  • Executing SSIS packages within a virtual machine in Azure
  • Using Azure Data Factory and what is called Lift and Shift
  • Using pipelines/data flows within Azure Data Factory

The presentation begins by discussing these potential things you may be looking to do with SSIS in the cloud. The main focus of the webinar is on lift and shift so from here we’ll look at how to design packages that allow you to connect Azure itself with the Azure Feature Packs in the SSIS versions including a demo. Azure Features Packs have:

  • Tons of Connection Managers such as Azure Storage, Azure Data Lake, Azure Resource Manager and HDInsight
  • Tasks – we’re still in SSIS so the concept of Tasks (blob upload/download, Azure SQL DW upload, HDInsight Hive, Pig and Create Cluster, etc.) and data flow components (blob source/destination, Data Lake Store source/destination, etc.) still exists

The Feature Pack doesn’t add new transforms as these tools are already an established piece of SSIS, but these new features allow us to connect to the cloud services. Manuel’s demo will dive into this and cite what he feels are the pros and cons. This in-depth webinar will also cover:

  • Azure Blob Source and Loading Azure SQL DB and the limitations
  • Provisioning Azure Data Factory
  • And of course, what is a lift and shift of SSIS and why you should consider it
  • Azure-SSIS Integration runtime
  • ADF Data Flows

So, if you’re interested in learning more about managing and executing SSIS in Azure with lift and shift, this webinar is for you. You can watch the complete webinar below. To view the presentation files, click here.


Looking for more training? We've got you covered with free training every Tuesday at 11 AM ET, our On-Demand Learning platform with 50+ courses on Power BI, Azure, Business Intelligence, SQL Server, and much more, plus our live boot camps and workshops. 

For a limited time our training courses are 50% off! Check out our website or click the link below to learn more and get started enhancing your skills and expanding your knowledge. There's no better time to begin your learning journey with our huge 50% off training sale!

Sign-up now and get instant access

Leave a comment

Free Trial

On-demand learning

Most Recent

private training

Hackathons, enterprise training, virtual monitoring