The Biml Package Generator provides the ability to create packages from Business Intelligence Markup Language (Biml). Biml is an XML-based language that allows you to describe your BI solution in a declarative fashion, similarly to using HTML to describe how a web page should appear. In addition, you can embed BimlScript (C# or VB.NET code) into Biml, in the same way that ASP.NET works with HTML. This allows for large numbers of packages to be created with a minimal amount of code.

For examples of using Biml, please see the samples and tutorials page.

To add a Biml file to the project, right-click on the project, or on the Data Sources, Data Source Views, or SSIS Packages folders. The context menu will have an Add New Biml File menu opton. This will add a Biml file to the Miscellaneous folder in the project.
BimlPackageGenerator1.png

Opening the Biml file will launch Visual Studio's XML editor, with Intellisense for the Biml language. If Intellisense is not working, see Manually Configuring Biml Package Generator. To learn more about the Biml language, right-click on the .biml file and choose Learn More About Biml from the context menu.
BimlPackageGenerator2.png

Here's a simple example of Biml code to create a package that contains a data flow:
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Packages>
        <Package Name="MyTestPackage" ConstraintMode="Linear" AutoCreateConfigurationsType="None">
            <Tasks>
                <Dataflow Name="My Data Flow">
                </Dataflow>
            </Tasks>
        </Package>
    </Packages>
</Biml>


After adding Biml code to a file, it can be checked for errors by choosing the Check Biml for Errors option from the context menu.
BimlPackageGenerator3.png

A Biml file can be expanded into one or more SSIS packages by choosing Expand Biml File from the menu. Expanding a file will automatically run an error check.
BimlPackageGenerator4.png

If the Biml file was expanded successfully, it will be added to the SSIS Packages folder in the project.
BimlPackageGenerator5.png

The Biml Package Generator is a plugin that leverages the Biml compiler from Varigence. This version of the Biml compiler has been provided free of charge for BIDS Helper users.

Last edited Jun 7, 2011 at 5:02 PM by johnwelch, version 10

Comments

geoffclark Dec 7, 2011 at 8:54 AM 
Resolved my query by guessing could not find any documentation.
Answer:
<#@ assembly name="C:\\Program Files\\Reference Assemblies\\Microsoft\\Framework\\v3.5\\System.Data.DataSetExtensions.dll" #>
solved my issue, I wanted to add DataSetExtensions so I could simplfy my script by using linq

geoffclark Dec 6, 2011 at 4:57 PM 
How do you add an assembly reference to a BIML script?

dgosbell Oct 2, 2011 at 8:30 PM 
@jstephens704 - the name of this menu item was changed and the screen shot in the documentation is out of date. There is nothing missing in your install.

jstephens704 Sep 30, 2011 at 5:36 PM 
I am not seeing the Expand Biml File command when I right click the Biml file. I see a Generate SSIS Package in its place. Is this a change that the documentation hasn't picked up or am I missing something in the installation configuration?

Thanks,

johnwelch Jun 29, 2011 at 2:43 PM 
We're looking at that for a future release, but that feature is not currently available.

hDt Jun 29, 2011 at 5:14 AM 
is there a way to reverse engineer an existing package? right-click and go "create BIML from package" ?