Blog
How to Load Slowly Changing Dimension in Azure Using MERGE
A data warehouse is typically made up of fact and dimension tables that are loaded using different load patterns such as incremental vs. full; and...
SELECT SIFISO Celebrates a successful 2022 as a team
SELECT SIFISO celebrated the end of a successful and productive 2022 at Cradle Moon Lakeside Game Lodge in Muldersdrift, Gauteng from 2 December to...
Export data from a Power BI dashboard
Step 1: Open a dashboard in the Power BI service and select a tile with a visual. Step 2: From the upper right corner of the tile, open the More...
Team Announcement
We are pleased to announce that two of our staff members have been offered permanent positions within Select Sifiso. We offer permanent positions on...
Giving Back to Deserving Communities
SELECT SIFISO takes its commitment to CSI seriously and we make time to contribute to worthy causes in our own unique ways. As an IT company, we...
The People’s Race
Sunday, 6th November 2022 our team participated in the 27th “The People’s Race”. The race took place at the FNB Stadium in Nasrec, Johannesburg. ...
Extract & Save SQL Statements in Execute SQL Tasks using C#
Abstract This article explains how to extract and save SQL Statements in Execute SQL Tasks of an SSIS package using C# programming language....
Programmatically Create Data Flow Task inside a Sequence Container Using C#
Abstract This article explains how to create an SSIS package with a Data Flow Task inside a Sequence Container using C# programming language....
Presenting at Upcoming (12/05/2015) Johannesburg SQL User Group Meeting
Join me at the Johannesburg SQL Server Group Meeting where I will be presenting the first session on integration of SQL Server Data Quality Services...
Programmatically Import Flat File Data Source into SQL Server 2008 Using SSIS’s Script Task Tool
Abstract This article demonstrates creating a SQL Server Integration Services package that imports a text file into SQL Server database table using...
Programmatically Execute File System Package Task Using C#
Abstract This article explains how to execute an SSIS package task of a package that is stored in a file system. Requirements Microsoft Visual...
Programmatically Import Delimited Text File with Derived Columns into Flat File Destination Using SSIS’s Script Task Tool
Abstract This article is in response to a request that was sent by one of my blog's subscribers regarding scripting an SSIS package with derived...
Extract & Save SQL Statements of Execute SQL Tasks in a ForEach Loop Container using C#
Abstract This article explains how to extract and save SQL Statements found in Execute SQL Tasks of an SSIS package that contains ForEach Loop...
Programmatically Insert into SQL Server Table from an Excel File Using SSIS Script Tasks
Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Script Task component....
Programmatically Load and Update Connection Managers of SSIS Package Template
Abstract Recently, I have been contracting on a project that involved updating existing SSIS Package Templates. Thus, this article will demonstrate...
Join Our Newsletter
Subscribe to get our latest and best thinking on the most definitive workforce topics affecting HR leaders and organizations today.