Business Intelligence Markup Language - SQL Server Integration Services Design Patterns - page 485

Figure 19-8 . Dynamically-built incremental load SSIS package
Testing will reveal the other SSIS packages perform similarly.
Conclusion
In this chapter, we have taken a brief tour of some of the functionality of Business In-
telligence Markup Language. We have demonstrated its usefulness as a domain-specif-
ic language for generating SSIS design patterns, focusing on the incremental load pat-
tern. In the final example, we demonstrated how Biml's integrated .NET functionality,
BimlScript, can be used to create a patterns-based approach to building four SSIS
packages using a tried-and-true data integration pattern (incremental load). On my ma-
chine, the four packages were generated in a matter of seconds. I assure you, based on
testing, Biml can produce hundreds of incremental load SSIS packages in a matter of
minutes. This is game-changing technology, because generating hundreds of SSIS
packages—even using templates and patterns—can easily consume data integration
developer-months.