Workbook

turned on silver imac with might mouse and keyboard

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

2 Comments / Creating SSIS Packages, Excel Workbooks, OLEDB Connection / By

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 the …

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

modern opened laptop on desk near cup

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

58 Comments / Excel Workbooks, Execute SQL Task, Reading SSIS Packages / By

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 »