Hadi Fadlallah

Biml alternatives: Building SSIS packages programmatically using ManagedDTS

SQL Shack

Posted on March 25, 2020

In this article, we will first illustrate how to create, save and execute SSIS packages using ManagedDTS in C#, then we will do a small comparison with Biml.

Tags: biml manageddts c# ssis sql server

An overview of the SSIS FTP Task

SQL Shack

Posted on March 18, 2020

In this article, we will explain the File Transfer Protocol (FTP), and we will give an overview of the FTP task in SQL Server Integration Services (SSIS) and FTP connection manager.

Tags: ftp ssis

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.

Tags: biml c# ssis

Monitoring activities using sp_WhoIsActive in SQL Server

SQL Shack

Posted on March 16, 2020

In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.

Tags: sp_whoisactive sql server

Extending Biml with C# scripts

SQL Shack

Posted on March 16, 2020

In this article, we will explain BimlScript, which is an extension of this markup language with VB or C# scripts.

Tags: biml c# ssis

Converting SSIS packages to Biml scripts

SQL Shack

Posted on March 13, 2020

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 the script.

Tags: biml c# ssis

Using Biml scripts to generate SSIS packages

SQL Shack

Posted on March 13, 2020

In this article, we will explain how to generate 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.

Tags: biml c# ssis

SSIS: Execute T-SQL Statement Task vs Execute SQL Task

SQL Shack

Posted on March 4, 2020

In this article, we will give an overview of the Execute T-SQL Statement Task, and we will make a small comparison with the Execute SQL Task which is more popular.

Tags: sql sql server ssis

How to get GraphLayout XML from programmatically generated SSIS package?

Stack Overflow

Posted on March 2, 2020

What is the SSIS package GraphLayout? Is it readable in programmatically generated SSIS package?

Tags: xml c# ssis

Getting started with Biml

SQL Shack

Posted on February 26, 2020

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 good resources to learn this technology.

Tags: biml ssis