Hadi Fadlallah

Posted on April 14, 2020

Glad to annouce that we have created a NuGet package for the SchemaMapper class library. You can check it on the following link: NuGet Gallery - SchemaMapper 1.1.0

Posted on April 2, 2020

DTExec is a tool used to configure and execute SQL Server Integration Services (SSIS) packages. Many developers and database administrators use this tool, especially when automating the package execution using third-party applications or non-supported programming languages. This article will introduce this tool to you, also help you understand how and... [Read More]

Posted on March 26, 2020

In this article, we will illustrate another Biml alternative, which is the EzApi class library, and we will make a comparison between both technologies.

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.

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.

Posted on March 18, 2020

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.

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.

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.

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.

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.