Learn how to streamline SQL Server Integration Services (SSIS) development using the Don't Repeat Yourself (DRY) principle in this 52-minute conference talk. Discover how to leverage Biml (Business Intelligence Markup Language) and BimlScript to generate SSIS packages from database metadata, implement changes across multiple packages efficiently, and separate and reuse common code. Explore techniques to automate tedious tasks, handle metadata and schema changes, and significantly reduce development time for large-scale SSIS projects. Gain insights into agile SSIS development practices that can help you complete in a day what previously took over a week.
Don't Repeat Yourself - An Introduction to Agile SSIS Development
PASS Data Community Summit via YouTube
Overview
Syllabus
24 Hours of PASS: Don't Repeat Yourself - An Introduction to Agile SSIS Development
Taught by
PASS Data Community Summit