Hadi Fadlallah

Posted on September 9, 2019

In this article, I will give an overview of Execute SQL Task in SSIS and I will try to illustrate some of the differences between writing an expression to evaluate SqlStatementSource property or writing this expression within a variable and change the Execute SQL Task Source Type to variable.

Posted on August 30, 2019

In this article, I will give an overview of SSIS OLE DB Destination and SQL Server Destination and I will try to illustrate some of the difference between both destination components based on my personal experience, SSIS official documentation and some other experts experience in this domain.

Posted on August 27, 2019

In this article, I will first give an introduction about SSIS expressions, then I will describe briefly the Expression Task and how to Evaluate a variable as expression. Then I will do a comparison between these two features to illustrate the similarities and differences between them.

Posted on August 22, 2019

SQL Server Integration Services provides a wide variety of features that helps developers to build a robust Extract, Transform and Load process. After many years contributing to SSIS related tags on Stackoverflow.com, I can say that many developers have some misunderstanding about SSIS features (SSIS OLE DB Source, SSIS Expressions,... [Read More]

Posted on August 22, 2019

Handling NUL (\x00) value in flat files using SQL Server Integration Services.

Posted on August 15, 2019

While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation: Parallel (All Objects will be processed in a single transaction): Used for batch processing, all tasks run in parallel inside one transaction. Sequential (Transaction mode): One... [Read More]

Posted on August 14, 2019

Using NumberFormat property while manipulating Microsoft Excel worksheets using SSIS.

Posted on July 29, 2019

How can I extract all objects mentioned in a SQL Command using C#?

Posted on June 16, 2019

Posted on June 14, 2019

Explaining the validation types performed when using OLE DB destination component in SSIS