Select Sifiso

API

Using REST API in SSIS to Extract Top 100 User Tweets

Abstract The growing popularity of the use of social networks by businesses indicate a possible change in ETL requirements. Part of this change is that developers had to revise existing ETL model such that it caters for sourcing of data off the internet in addition to the traditional flat files or OLE/ODBC Connections. In this …

Using REST API in SSIS to Extract Top 100 User Tweets Read More »

Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model. In this article, I will demonstrate the scripting of Integration Services Catalog packages using C#. Requirements Microsoft Visual Studio 2010 or later Article We begin by launching Microsoft Visual Studio and create a …

Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C# Read More »

Load Integration Services Assembly File Into Visual Studio 2010 Project

Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model. This API is accessed through the Microsoft.SqlServer.Management.IntegrationServices.dll assembly file. However, when you create an SSIS 2012 project/package using Visual Studio 2010, the assembly file is missing. In this post, I will show you …

Load Integration Services Assembly File Into Visual Studio 2010 Project Read More »