Pubudu Dewagama

MSBI : SQL Server Integration Service (SSIS) - Merge Transformation

The Merge Transformation merges two sorted data sets and outputs a sorted data set and by Merge it really means a “Sorted Union All”. You ...

MSBI : SQL Server Integration Service (SSIS) - Merge Transformation

Reviewed by Pubudu Dewagama on 8:58:00 PM Rating: 5

In this post I'm going to explain How to use Derived column Transformation in SSIS Development Environment.Below are the steps to conve...

MSBI : SQL Server Integration Service (SSIS) - Derived Column Transformation

Reviewed by Pubudu Dewagama on 3:57:00 AM Rating: 5

SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL ope...

MSBI : SQL Server Integration Service (SSIS) - Loading Data from Excel to SQL Server Table

Reviewed by Pubudu Dewagama on 7:47:00 AM Rating: 5

The hierarchy flattening transform can analyze a parent-child relationship and provide a description of the hierarchy in a flattened format...

SAP Business Objects Data Services - Hierarchy Flattening Transform

Reviewed by Pubudu Dewagama on 7:31:00 PM Rating: 5

SQL transformation is used to perform standard SQL Operations in Data services but it is not supports all SQL operations. It supports only ...

SAP Business Objects Data Services - SQL Transform

Reviewed by Pubudu Dewagama on 9:50:00 PM Rating: 5