Hadi Fadlallah

Posted on October 4, 2019

In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.

Posted on October 4, 2019

In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.

Posted on September 25, 2019

In this article, we will first give an overview on SSIS derived column transformation, then we will run an experiment to check if there is any difference between adding multiple expressions within one derived column transformation and adding a derived column transformation for each expression.

Posted on September 17, 2019

In this article, I will describe the difference between using output parameters and result sets within Execute SQL Task in SSIS.

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]