SSIS in the Cloud

Part Of The On-Demand Courses


  • Create SSIS packages that interact with various Azure Storage options
  • Introduction to Azure Data Factory
  • Deploy packages to an Azure SQL Database
This course includes:

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.



Module 00 | Class Introduction
06m 33s total


Module 00A | Class Introduction
06m 33s


Module 01 | Getting Started with Azure
51m 81s total


Module 01A | Navigating the Azure Portal
13m 57s


Module 01B | Resource Groups
13m 17s


Module 01C | Azure SQL DB & Azure Storage
25m 07s


Module 02 | SSIS Hosted On-Prem
163m 11s total


Module 02A | Azure Feature Pack
12m 02s


Module 02B | Azure Blob Upload Task
25m 04s


Module 02C | Azure Blob Download Task
32m 05s


Module 02D | Azure Blob Source to Azure SQL DB
30m 52s


Module 02E | Flat File Source
12m 59s


Module 02F | Azure SQL DB to Azure SQL DB
18m 24s


Module 02G | SSIS Deployment
15m 45s


Module 02H | SSIS Package Execution
17m 20s


Module 03 | Working with Azure Data Factory
10m 51s total


Module 03A | Provisioning Azure Data Factory
10m 51s


Module 04 | Azure Lift and Shift
58m 43s total


Module 04A | Provisioning Azure SSIS Integration Runtime
17m 19s


Module 04B | Visual Studio Deployment
10m 53s


Module 04C | Management Studio Deployment
06m 19s


Module 04D | Execute SSIS Packages from Azure
11m 25s


Module 04E | Execute SSIS Packages from SSMS
13m 27s


Module 05 | Scheduling a Pipeline
13m 31s total


Module 05A | Schedule Triggers
13m 31s


Module 06 | Monitoring
07m 34s total


Module 06A | Azure Data Factory
07m 34s



Training Content Manager

As a Training Content Manager, Consultant and Trainer with Pragmatic Works, Manuel uses his extensive knowledge of the BI Stack (SSRS, SSIS, SSAS etc.) to deliver exciting and engaging content. He also has experience with T-SQL, DAX, Power Platform and Azure Data Services. Manuel, however, is known for his impressive knowledge of the Microsoft Power BI tool. A native of Puerto Rico, He graduated from the University of Central Florida and loves being involved in the world of business intelligence. Manuel is a thought leader in the BI community.

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Data Quality Services (SQL 2012/2014 only)
    • Data Quality Client (SQL 2012/2014 only)
    • Follow this installation guide: (https://file.ac/CtasreVWQEA/Pragmatic%20SSIS%20Master%20Installation%20Guide.docx)

What to Know Before Class

We recommend first taking our Introduction to SSIS course prior to taking this one.

Great instructor.


Very helpful, thank you!


Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!