Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Script Task component....
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...
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...
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...