Don't Repeat Yourself - An Introduction to Agile SSIS Development

Overview

Learn to streamline SSIS development using Biml and BimlScript. Generate packages from metadata, implement changes efficiently, and reuse code across projects for faster, more agile development.

Syllabus

• Introduction to Agile SSIS Development
Overview of SSIS (SQL Server Integration Services)
Importance of agility in ETL processes
• Introduction to Biml and BimlScript
What is Biml (Business Intelligence Markup Language)?
Understanding BimlScript and its role in automation
• Setting Up the Development Environment
Installing necessary tools and extensions
Configuring SSIS projects for Biml
• Generating SSIS Packages from Metadata
Introduction to metadata-driven development
Mapping metadata to BimlScript
Hands-on: Creating a sample package
• Implementing Efficient Changes
Strategies for managing changes in SSIS projects
Using Biml to propagate changes across packages
• Reusing Code Across Projects
Identifying reusable components in SSIS
Creating and managing code libraries with Biml
• Best Practices for Agile SSIS Development
Code organization tips
Testing and validation strategies
Performance considerations
• Case Studies and Real-World Applications
Analyzing successful Biml implementations
Lessons learned and pitfalls to avoid
• Conclusion and Further Learning
Summary of key concepts
Resources for continued study in Biml and SSIS development

---

Subjects

Conference Talks