Skip to main content

Getting Started with BimlScript - Part 1

The first step for getting started with Biml is installing BimlExpress for Visual Studio Code. If you have not already, please see the instructions available at the BimlExpress for Visual Studio Code page. When your session is not licensed, BimlExpress shows an activation prompt with options to enter or request a product key, as Account and Licensing describes.

To create a Biml file:

  1. Begin by creating a new folder.
  2. Name the folder Getting Started with BimlScript, and open it in Visual Studio Code.
  3. In the Explorer, create a new file in the folder.
  4. Name the file My Package.biml. BimlExpress treats every file with the .biml extension as a Biml file.

Now that a Biml file has been created, let’s start writing Biml:

  1. Open My Package.biml in the editor. The new file is empty, so type the opening and closing Biml tags: <Biml xmlns="http://schemas.varigence.com/biml.xsd"> and </Biml>.
  2. Add the following Biml between the Biml tags.
<Packages>
<Package Name="MyPackage" ConstraintMode="Linear">
<Tasks>
<Dataflow Name="My Data Flow">
</Dataflow>
</Tasks>
</Package>
</Packages>

Note that if syntax highlighting and intellisense aren’t working, check that the file name ends in .biml and that BimlExpress is installed as the BimlExpress for Visual Studio Code page describes.

With our Biml added, we can now generate a SSIS package:

  1. In the Explorer, right click the My Package.biml file. In its context menu, click Build Biml.
  2. After a few moments, you’ll see that a new package named MyPackage.dtsx has been written to the output/ssis folder of your workspace. Open MyPackage.dtsx to see it.

By clicking on Build Biml, the Biml file was sent to the Biml engine, which is included in BimlExpress. The Biml engine then compiled the Biml file to create the SSIS package. Finally, BimlExpress wrote the newly generated package to the output/ssis folder, which the Ssis: Target Folder setting controls. Build and Validate describes the output folders. To open the package in the SSIS designer, use your SSIS development tool, such as Visual Studio with the SQL Server Integration Services Projects extension, which is separate from BimlExpress.

Next walkthrough in the Getting Started with BimlScript series: Getting Started with BimlScript - Part 2