Abstract We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for client’s business users to be able to design, develop and publish ad hoc reports using Report Builder 3.0. During unit testing we had one of the Business Analysts (BA) in our team simulate business user experience [Read More →]
select SIFISO Hey, let's DEV IT!
Sifiso W. Ndlovu
I am a certified Microsoft Professional based in Johannesburg, South Africa.
I have over 6 years working within Microsoft SQL Server and .Net environments.
I am currently studying towards Masters in IT at the University of Johannesburg.
Execute Process Task – Compress File Using 7-Zip
November 11, 2012 — SifisoAbstract 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 using 7-Zip. Requirements Microsoft Visual Studio 2005 or later 7-Zip SIFISO_Test Article Recently I have been involved in a project whereby I have been required to extract data into csv [Read More →]
Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#
August 14, 2012 — SifisoAbstract 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 [Read More →]
Load Integration Services Assembly File Into Visual Studio 2010 Project
August 6, 2012 — SifisoAbstract 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 [Read More →]
