Duration: 60 minutes
Track: BI Platform Architecture, Development & Administration
SSIS (SQL Server Integration Services) is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.
It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml (Business Intelligence Markup Language) and BimlScript to generate SSIS packages from database metadata and implement changes in all those packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code. See how Biml allows you to complete in a day what once took more than a week!
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
Community Evangelist, PASS
Cathrine loves teaching and sharing knowledge, and currently works as a Community Evangelist for PASS, a global community that enables Microsoft Data Platform professionals to connect, share and... View More