Database Reference
In-Depth Information
CHAPTER 20
Biml and SSIS Frameworks
Elegant solutions lead to more elegant solutions. This is one feature of elegant solutions,
and Business Intelligence Markup Language (Biml) is an elegant solution. Biml facilit-
ates the rapid development of SSIS packages. As impressive as this is, Biml can do
more - much more. We will not be able to explore Biml's complete feature set in this
volume, but I would like to examine some additional functionality.
In this chapter, we will build on the example file from the Business Intelligence
Markup Language chapter, adding some additional files and functionality.
Using Biml with an SSIS Framework
Appendix A shows the source code for building a file system-based SSIS Framework.
Because SSIS 2014 supports backwards-compatibility via the Package Deployment
Model, you can use this Framework in all versions of SSIS (to date). The examples in
this chapter are designed to interact with the Framework described in Appendix A.
Note To complete the examples that follow you will need to implement the Frame-
work in Appendix A and complete the examples in the chapter titled Business Intelli-
gence Markup Language .
Adding SSIS Package Metadata to the Framework
Search WWH ::




Custom Search