Failing to Preview Report in Report Builder

+-*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 »

Compress Dynamic Files Using 7-Zip in SSIS

+-*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 aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL Server Integration Services‘s Execute Process Task to compress dynamic files into… Read More »

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… Read More »

Execute Process Task – Compress File Using 7-Zip

+-*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 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#

+-*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… 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… Read More »

SSIS 2012: Programmatically Create Catalog

+-*Abstract I have a client that has already started migrating existing SQL Server environments to SQL Server 2012. Thus, this article will demonstrate creating a catalog and catalog folder using a Script Task component. Requirements Microsoft Visual Studio 2010 Article We begin by launching Microsoft Visual Studio and create a new Integration Services Project which… Read More »

Programmatically Load and Update Connection Managers of SSIS Package Template

+-*Abstract Recently, I have been contracting on a project that involved updating existing SSIS Packate Templates. Thus, this article will demonstrate loading and updating of SSIS Package Templates using a Script Task component. Requirements Microsoft Visual Studio 2008 SQL Server 2005 (or later editions) Article We begin by launching Microsoft Visual Studio and create a… Read More »

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 columns that sources text file and writes data into another text file. Thus, this article demonstrates creating a SQL Server Integration Services package that imports a text file with derived… Read More »

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 a Script Task component. Requirements Microsoft Visual Studio 2008 SQL Server 2005 (or later editions) create_table_script.txt flat_src.txt selectSIFISO_Flat_File_Source_into_OLE_DB_Destination_Using_CSharp.txt Article We begin by launching Microsoft Visual Studio and create a new Integration Services Project… Read More »