Azure DevOps and the SSIS Development Lifecycle

on YouTube ↗01h 12m

" summary

Shows an end-to-end DILM demo: code in TFVC, Azure DevOps pipelines that use an ssis build and deploy tasks, an ispac file artifact, and a self-hosted agent on a laptop to run builds and triggers. Demonstrates MSBI quirks (XML merges break text-based CI), deployment to SSISDB/Azure SSIS IR, PowerShell test step that asserts a single-row result, and real failures and recoveries so viewers see what actually works and what breaks.

AI-written summary · about

" chapters (24)

1. 0:00Introduction
2. 1:20History of CICD
3. 3:20Azure DevOps
4. 4:50Azure DevOps Walkthrough
5. 10:25Checked In Repository
6. 11:22Questions
7. 11:38Agents
8. 13:15Personal Access Tokens
9. 16:18Powershell Configuration
10. 19:04Azure Pipeline
11. 28:03Azure Build Pipeline Demo
12. 39:14Bonus
13. 40:32Framework
14. 40:56Execute Package
15. 42:46Run Package
16. 44:46Enable CI
17. 45:28Enable Continuous Integration
18. 46:15Automation
19. 46:30Troubleshooting
20. 47:16Testing in PowerShell
21. 48:38Enabling Continuous Integration
22. 53:51Azure Data Factory
23. 55:44Stop Azure SSISr
24. 58:25Run Demo 3

" related talks

• 53mAzure DevOps and the SSIS Development LifecycleAndy Leonard · Global Summer 2020 Azure Data Fest 2020
• 01h 10mContinuous Integration for the BI DeveloperWolfgang Strasser · Global Azure 2021
• 06mIntroduction to Azure DevOpsDonovan Brown · Azure DevOps Launch 2018
• 46mDatabase CI/CD with Docker Containers and Azure DevOpsChris Taylor · SQLBits 2020
• 01h 03mA lap around Azure DevopsJakob Ehn · NDC London 2019
• 56mAzure DevOps for .NET TeamsMartin Woodward · .NET Conf 2018
• 48mConnecting the dots of Azure SQL DevOpsMuazma Zahid · SQLBits 2023
• 46mAutomating Infrastructure as Code with Azure DevOpsErick Moore · Indy Cloud Conf 2020