Learn Biml for SSIS
A few months ago, I started writing a new series of articles
about Business Intelligence Markup Language (BIML) for the SQL Shack website. After
finishing writing about using BIML in SQL Server Integration Services, I would
like to share with you these articles:
Getting
Started With Biml
In this article, we will give a brief overview of BIML by
showing how it can be installed and how we can use it to generate SSIS packages
using the BimlExpress tool. Finally, we will provide some useful resources to
learn this technology.
Converting
SSIS packages to Biml scripts
In this article, we will explain how to generate scripts
from existing SSIS packages by showing all related options. Then, we will
analyze the generated script and identify how each object is mentioned in it.
Using
Biml scripts to generate SSIS packages
In this article, we will explain how to create SSIS packages
using business intelligence markup language by providing a step-by-step guide
where we will illustrate how to configure each object and how to use variables,
expressions, and parameters within the package.
BimlScript:
Extending Biml with C# scripts
In this article, we will explain BimlScript, which is an
extension of this markup language with VB or C# scripts.
Using
external C# script files within Biml
In this article, we will explain how to store these VB or C#
scripts within external files and use them within Biml scripts. Also, we will
mention how to create extension methods within these C# scripts.
Biml
alternatives: Building SSIS packages programmatically using ManagedDTS
In this article, we will first illustrate how to create,
save, and execute SSIS packages using ManagedDTS in C#. Then we will make a
small comparison with Biml.
Biml
alternatives: Building SSIS packages programmatically using EzAPI
In this article, we will illustrate another Biml
alternative, which is the EzApi class library, and we will make a comparison
between both technologies.
PHP Voting System with jQuery AJAX
ReplyDeleteHow to Create a Simple and Efficient PHP Cache
Create Dynamic Google Pie Chart in PHP and MySQL
Get directions & show routes PHP
How To Create a Responsive Top Navigation Menu
jQuery Loop through JSON Data
Advanced Search using PHP
Simple Show Hide Menu Navigation
NodeJS Simple way to send SMTP mail