Language

Introduction to Business Intelligence Markup Language (BIML) for SSIS

By: Koen Verbeeck   |   Updated: 2018-09-12   |   Comments (3)   |   Related: More > Integration Services Development



Problem

With Microsoft SQL Server Integration Services (SSIS), you can build powerful
and flexible packages to manage your enterprise-wide ETL solutions. However, every
ETL project has some repetitive tasks: you need to import 20 different flat file
exports from the ERP system, you need to load 15 dimensions into the data warehouse
and so on. With SSIS out-of-the-box, you are forced to create multiple individual
packages which is very time consuming due to the lack of easy code reuse. In a typical
BI project, the ETL implementation can easily take up 60% of the project time, so
it is beneficial if the development time of similar SSIS packages can be cut down.

Solution

Biml, which stands for Business Intelligence Markup Language, offers

Read More