Hadi Fadlallah

Posted on January 10, 2022

This article will explain how to create a SQL Server CLR function stored in a C# class library without creating a SQL Server database project. We will first briefly explain the concept of .NET common language runtime (CLR) and then build a C# class library using the .NET framework. Then,... [Read More]

Posted on December 30, 2021

This answer explains why the milliseconds part is removed when passing a DateTime value as a parameter in a OLE DB source SQL Command. Besides, it explains the different data types systems used in SSIS.

Posted on December 29, 2021

How to split a comma seperated value passed as a parameter to an SQL Command used in the SSIS OLE DB Source when the database does not support STRING_SPLIT() system function?

Posted on November 25, 2021

This article explains both the SSIS term extraction and term lookup components. Besides, it illustrates the use cases of each one of them.

Posted on November 19, 2021

This article explains the SSIS Script task and Script component, the scripting tools available in the SQL Server Integration Services (SSIS).

Posted on November 11, 2021

Is it Possible to Load data to MongoDB Using SSIS? If yes tools required to achieve? Does MongoDB Support all the SQL Operations?

Posted on November 3, 2021

This article explains the SSIS XML Source and the SSIS XML task, which are the XML-related components in the SQL Server Integration Services.

Posted on October 5, 2021

This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode

Posted on September 29, 2021

SSIS Merge Join and Merge transformations are two similar components used to combine two input data sources into one output. This article explains both transformations and illustrates when and how to use each one of them.

Posted on September 8, 2021

This article explains the SSIS pivot transformation and how it differs from the unpivot transformation.