Select Sifiso

Excel Workbooks

Multiple Tagging of TFS Work Items Using Excel

In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can be used to manage SQL Server-related development. Some of the feedback I received from the article was the issue of tagging items in Excel. This article illustrates how TFS work items can be multi-tagged using …

Multiple Tagging of TFS Work Items Using Excel 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 …

Execute Process Task – Compress File Using 7-Zip Read More »

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. Requirements Microsoft Visual Studio 2008 (or later editions) SQL Server 2005 (or later editions) AdventureWorks2008 database (downloadable database file available here) Article If the above requirements are all met, we will begin by launching Microsoft …

Programmatically Insert into SQL Server Table from an Excel File Using SSIS Script Tasks Read More »

Extract SQL Statements in Execute SQL Tasks and save them into an Excel Workbook using C#

Abstract This article explains how to extract SQL Statements found in Execute SQL Tasks of an SSIS package and save them into an Excel Workbook using C# programming language. Requirements Microsoft Visual Studio 2008 Article This article continues from another article which can be found here. Launch Visual Studio 2008 and create an Integration Services …

Extract SQL Statements in Execute SQL Tasks and save them into an Excel Workbook using C# Read More »