schedule BIML generation of scripts?

Question

I have some BIML scripts that (working together)

1. check a folder for cvs files
2. create packages to import those files

This works like a charm, however, wehenever a file is added (or removed) to that folder, I need to regenerate the packages by running the BIML scripts.

Can this be automated? So othat the biml script is run, the packages are created and the packages are then executed?

Answer 1

As Amira mentions, you need a licensed installation of the BimlStudio product.

The command you are looking for is bimlc

BimlC references

• Building using the Command Line
• Biml Compiler (bimlc.exe) options

I thought we had a chapter on CI/CD in The Biml Book but I'm not seeing it at the moment. Bimlc is mentioned in the SSAS chapter but I thought there was more info on it.

Answer 2

By automating the right click/generate SSIS package you mean the conversion Biml XML into a DTSX's XML.

BidsHelper helps you achieve that using BimlExpandPlugin class

In the class BimlExpandPlugin, you'll find version specific calls to the BidsHelper.CompileBiml

ValidationReporter validationReporter = BidsHelper.CompileBiml(typeof(AstNode).Assembly, "Varigence.Hadron.BidsHelperPhaseWorkflows.xml", "Compile", bimlScriptPaths, new List < string > (), tempTargetDirectory, projectDirectory, SqlServerVersion.SqlServer2008, ssisVersion, SsasVersion.Ssas2008);

ValidationReporter validationReporter = BidsHelper.CompileBiml(typeof(AstNode).Assembly, "Varigence.Hadron.BidsHelperPhaseWorkflows.xml", "Compile", bimlScriptPaths, new List < string > (), tempTargetDirectory, projectDirectory, SqlServerVersion.SqlServer2005, SsisVersion.Ssis2005, SsasVersion.Ssas2005);

Varigence offers that functionality existing for BidsHelper with their product Varigence Mist (now called BimlStudio).

Note :

The BIDS Helper add-on for Microsoft SQL Server Business Intelligence Development Studio (BIDS) and the Varigence Mist (now called BimlStudio) integrated development environment; both tools translate Biml metadata into SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) assets for the Microsoft SQL Server platform. However, emitters can be created to compile Biml for any desired BI platform.