<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

Join our SSIS in the Cloud class. Learn to create SSIS packages with Azure Storage, Blob Storage, SQL DB. From creating, deploying, executing packages on-premises to leveraging Azure Data Factory's Lift and Shift, we cover it all.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

This SSIS in the Cloud class will take users through the process of creating simple SSIS packages that interact with various Azure Storage options like Azure Blob Storage and Azure SQL DB. It will start with creating, deploying, and executing packages that move data in the Cloud via an on-premises solution. Then users will be introduced to Azure Data Factory and the feature known as Lift and Shift which will allow us to deploy our packages to an Azure SQL Database and execute them uses Cloud resources. Users should have a basic understanding of SSIS prior to watching this class.

Course Outline ( Free Preview)

SSIS in the Cloud - What you need to get started

Module 00 - Class Introduction

Module 01A - Getting Started with Azure (Navigating the Azure Portal)

Module 01B - Getting Started with Azure (Resource Groups) 13 min.

Module 01C – Getting Started with Azure (Azure SQL DB & Azure Storage) 25 min.

Module 02A - SSIS Hosted On-Prem (Azure Feature Pack) 12 min.

Module 02B - SSIS Hosted On-Prem (Azure Blob Upload Task) 25 min.

Module 02C - SSIS Hosted On-Prem (Azure Blob Download Task) 32 min.

Module 02D - SSIS Hosted On-Prem (Azure Blob Source to Azure SQL DB) 31 min.

Module 02E - SSIS Hosted On-Prem (Flat File Source) 13 min.

Module 02F - SSIS Hosted On-Prem (Azure SQL DB to Azure SQL DB) 18 min.

Module 02G - SSIS Hosted On-Prem (SSIS Deployment) 16 min.

Module 02H - SSIS Hosted On-Prem (SSIS Package Execution) 17 min.

Module 03 - Working with Azure Data Factory (Provisioning Azure Data Factory) 11 min.

Module 04A - Azure Lift and Shift (Provisioning Azure SSIS Integration Runtime) 21 min.

Module 04B – Azure Lift and Shift (Visual Studio Deployment) 11 min.

Module 04C - Azure Lift and Shift (Management Studio Deployment) 6 min.

Module 04D - Azure Lift and Shift (Execute SSIS Packages from Azure) 11 min.

Module 04E - Azure Lift and Shift (Execute SSIS Packages from SSMS) 13 min.

Module 05 - Scheduling a Pipeline (Schedule Triggers) 14 min.

Module 06 - Monitoring (Azure Data Factory) 8 min.

This course includes:

  • 5+ hours of training
  • 21 Modules
  • * Access on mobile and browser
  • Certificate of Completion