Azure DevOps and the SSIS Development Lifecycle

on YouTube ↗53m

" summary

Shows how to put SSIS under Azure DevOps source control, build and deploy using SSIS Build and Deploy tasks, run pipelines on a self-hosted agent VM, and execute regression tests via Azure PowerShell calling the SSIS Framework (Community Edition). Demo maps repo to TFS, triggers CI on check-in, deploys to SSISDB, then runs a row-count test (expects 1 row — first run passes, second run fails because it inserts a second row).

AI-written summary · about

" chapters (9)

1. 0:00Introduction and agenda
2. 1:30SSIS as software development
3. 5:07Setting up source control
4. 10:51Repo and demo overview
5. 14:40Configuring build agents
6. 22:25Creating build pipelines
7. 31:30Automated testing
8. 41:49Pipeline chaining and deploy
9. 49:38Q&A and closing

" related talks

• 01h 12mAzure DevOps and the SSIS Development LifecycleAndy Leonard · All Things Open 2020
• 01h 10mContinuous Integration for the BI DeveloperWolfgang Strasser · Global Azure 2021
• 06mIntroduction to Azure DevOpsDonovan Brown · Azure DevOps Launch 2018
• 56mAzure DevOps for .NET TeamsMartin Woodward · .NET Conf 2018
• 01h 00mGetting started with Azure DevOpsDonovan Brown · NDC Oslo 2019
• 27mBuilding powerful DevOps pipelines with Microsoft Azure DevOpsAdmir Tuzović · Bosnia Agile Day 2018
• 01h 03mA lap around Azure DevopsJakob Ehn · NDC London 2019
• 46mAutomating Infrastructure as Code with Azure DevOpsErick Moore · Indy Cloud Conf 2020