Database Reference
In-Depth Information
In this chapter, we will leverage the free Biml functionality included with BIDS
Helper to dynamically generate SSIS packages.
Note An object containing Business Intelligence Markup Language is a Biml file .
Biml files are “executed” to generate SSIS packages.
Building Your First Biml File
Before we get started with Business Intelligence Markup Language, you will need to
download and install the latest version of BIDS Helper from ht-
tp://bidshelper.codeplex.com . Once it is installed, create a new SSIS solu-
tion and project named Biml2014 . In Solution Explorer, right-click the project name
and click Add New Biml File. The new file, BimlScript.biml , will be created and
assigned to the Miscellaneous virtual folder in Solution Explorer. Double-click the file
to open it in the editor.
The file begins with the most basic Biml construct, as shown in Listing 19-1 .
Listing 19-1 . Initial Biml Code
<Biml xmlns=" http://schemas.varigence.com/biml.xsd ">
</Biml>
Add XML so that your Biml file reads as shown in Listing 19-2 . As you type, note
IntelliSense auto-indents XML tags to produce well-formed code that is easier to read.
Listing 19-2 . Biml After Adding Package XML Metadata
<Biml xmlns=" http://schemas.varigence.com/biml.xsd ">
<Packages>
<Package Name="TestBimlPackage"
ConstraintMode="Parallel">
</Package>
</Packages>
</Biml>
 
 
 
 
Search WWH ::




Custom Search