Home
Solutions
- - - Database Development
      Database development is designing, creating a database or data model, and analyzing requirements and their intents as raw data.
      Learn More
    - Architecture & Design
      Software architecture refers to the fundamental structures of a software system and the discipline of creating such structures and systems.
      Learn More
  - - Programming
      Computer programming is the process of performing a particular computation or more generally, accomplishing a specific result.
      Learn More
    - Cloud Computing
      Cloud computing is the on-demand availability of computer system resources, especially data storage and computing power.
      Learn More
  - - ETL Development
      ETL provides the foundation for data analytics and machine learning workstreams. Through a series of business rules, ETL cleanses and organizes data.
      Learn More
    - Data Visualization & Reports
      Data and information visualization is an interdisciplinary field that deals with the graphic representation of data and information.
      Learn More
About
Blog
Contact
Search for:

Sifiso

Failing to Preview Report in Report Builder

by Sifiso | Oct 13, 2022 | Execute Report Definitions, Permissions, Report Builder, Report Builder 3, Report Manager, SQL Server 2012, SSRS, System Role

Abstract We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for the client's business...

Compress Dynamic Files Using 7-Zip in SSIS

by Sifiso | Oct 13, 2022 | Execute Process Task, ForEach Loop Container, Script Component

Abstract This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the...

Using REST API in SSIS to Extract Top 100 User Tweets

by Sifiso | Oct 13, 2022 | API, Data Flow Task, HTTP Connection, OLEDB Connection, Script Component

Abstract The growing popularity of the use of social networks by businesses indicate a possible change in ETL requirements. Part of this change is...

Execute Process Task – Compress File Using 7-Zip

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, Excel Workbooks, Execute Process Task, Microsoft Visual Studio 2010, SQL Server 2012, SSIS 2012

Abstract In this blog post I will demonstrate using SQL Server Integration Services's Execute Process Task to compress a csv file into a zip format...

Load Integration Services Assembly File Into Visual Studio 2010 Project

by Sifiso | Oct 13, 2022 | API, IntegrationServices, Managed Object Model, Microsoft Visual Studio 2010, SQL Server 2012, SSIS 2012, XML

Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. This API is...

SSIS 2012: Programmatically Create Catalog

by Sifiso | Oct 13, 2022 | Catalog, CatalogFolder, IntegrationServices, SMO Server, SSIS 2012

Abstract I have a client that has already started migrating existing SQL Server environments to SQL Server 2012. Thus, this article will demonstrate...

Programmatically Transfer SQL Server Objects (Schema) Using C#

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, OLEDB Connection, Schema, Transfer SQL Server Objects Task

Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Transfer SQL Server Objects...

Programmatically Transfer SQL Server Objects (Stored Procedure) Using C#

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, OLEDB Connection, Stored Procedure, Transfer SQL Server Objects Task

Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Transfer SQL Server Objects...

Programmatically Transfer SQL Server Objects (Views) Using C#

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, OLEDB Connection, SQL Views, Transfer SQL Server Objects Task

Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Transfer SQL Server Objects...

Programmatically Transfer SQL Server Objects (Tables) Using C#

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, OLEDB Connection, Transfer SQL Server Objects Task

Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Transfer SQL Server Objects...

Programmatically Execute SQL Server Package Task Using C#

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, Execute Package Task, OLEDB Connection

Abstract This article explains how to execute an SSIS package task of a package that is stored in an SQL Server. Requirements Microsoft Visual...

Programmatically Insert Conditional Split Transformation in Data Flow Task of SSIS Package Using C#

by Sifiso | Oct 13, 2022 | Conditional Split Transformation, Creating SSIS Packages, Data Flow Task

Abstract This article explains how to create an SSIS package with both Data Flow Task and Conditional Split Transformation connected together using...