Home
Solutions
- - - Database Development
      Database development is designing, creating a database or data model, and analyzing requirements and their intents as raw data.
      Learn More
    - Architecture & Design
      Software architecture refers to the fundamental structures of a software system and the discipline of creating such structures and systems.
      Learn More
  - - Programming
      Computer programming is the process of performing a particular computation or more generally, accomplishing a specific result.
      Learn More
    - Cloud Computing
      Cloud computing is the on-demand availability of computer system resources, especially data storage and computing power.
      Learn More
  - - ETL Development
      ETL provides the foundation for data analytics and machine learning workstreams. Through a series of business rules, ETL cleanses and organizes data.
      Learn More
    - Data Visualization & Reports
      Data and information visualization is an interdisciplinary field that deals with the graphic representation of data and information.
      Learn More
About
Blog
Contact
Search for:

Excel Workbooks

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

by Sifiso | Oct 14, 2022 | Creating SSIS Packages, Excel Workbooks, OLEDB Connection

Abstract This article explains how to Programmatically create an SQL Server Integration Services (SSIS) package with a Script Task component....

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

by Sifiso | Oct 13, 2022 | Excel Workbooks, Execute SQL Task, Reading SSIS Packages

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

by Sifiso | Oct 13, 2022 | Excel Workbooks, Team Foundation Server

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

by Sifiso | Oct 13, 2022 | Creating SSIS Packages, Excel Workbooks, Execute Process Task, Microsoft Visual Studio 2010, SQL Server 2012, SSIS 2012

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...

Database Development

Architecture & Design

Programming

Cloud Computing

ETL Development

Data Visualization & Reports

Excel Workbooks

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

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

Multiple Tagging of TFS Work Items Using Excel

Execute Process Task – Compress File Using 7-Zip

SOLUTIONS

COMPANY

RESOURCES

LEGAL

+27 11 044 9467

sifiso@selectsifiso.com