What You Need to Know Before
You Start
Starts 7 June 2025 18:20
Ends 7 June 2025
00
days
00
hours
00
minutes
00
seconds
Don't Repeat Yourself - An Introduction to Agile SSIS Development
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.
PASS Data Community Summit
via YouTube
PASS Data Community Summit
2544 Courses
52 minutes
Optional upgrade avallable
Not Specified
Progress at your own speed
Conference Talk
Optional upgrade avallable
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
- Introduction to Biml and BimlScript
- Setting Up the Development Environment
- Generating SSIS Packages from Metadata
- Implementing Efficient Changes
- Reusing Code Across Projects
- Best Practices for Agile SSIS Development
- Case Studies and Real-World Applications
- Conclusion and Further Learning
Overview of SSIS (SQL Server Integration Services)
Importance of agility in ETL processes
What is Biml (Business Intelligence Markup Language)?
Understanding BimlScript and its role in automation
Installing necessary tools and extensions
Configuring SSIS projects for Biml
Introduction to metadata-driven development
Mapping metadata to BimlScript
Hands-on: Creating a sample package
Strategies for managing changes in SSIS projects
Using Biml to propagate changes across packages
Identifying reusable components in SSIS
Creating and managing code libraries with Biml
Code organization tips
Testing and validation strategies
Performance considerations
Analyzing successful Biml implementations
Lessons learned and pitfalls to avoid
Summary of key concepts
Resources for continued study in Biml and SSIS development
Subjects
Conference Talks
