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...
How to Load Slowly Changing Dimension in Azure Using MERGE
read more
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...
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. ...
Latest Blog Post – Importing XML in SSIS
Using SSIS to Import HTTP-Based XML Document http://www.blogs.selectsifiso.com/?p=1009
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....
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...
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....
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 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...
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...
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...
Download & Save SSIS Packages from SQL Server 2008 Instance to XML Format
Abstract This article explains how to Programmatically download SQL Server Integration Services (SSIS) packages from an instance of SQL Server 2008...
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....