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:

SSIS 2012

SSIS 2012: Programmatically Create Catalog

by Sifiso | Oct 13, 2022 | Catalog, CatalogFolder, IntegrationServices, SMO Server, SSIS 2012

Abstract I have a client that has already started migrating existing SQL Server environments to SQL Server 2012. Thus, this article will demonstrate...

Load Integration Services Assembly File Into Visual Studio 2010 Project

by Sifiso | Oct 13, 2022 | API, IntegrationServices, Managed Object Model, Microsoft Visual Studio 2010, SQL Server 2012, SSIS 2012, XML

Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. This API is...

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

Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

by Sifiso | Oct 11, 2022 | API, Catalog, CatalogFolder, Creating SSIS Packages, Microsoft Visual Studio 2010, SMO Server, SQL Server 2012, SSIS 2012

Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. In this...

Database Development

Architecture & Design

Programming

Cloud Computing

ETL Development

Data Visualization & Reports

SSIS 2012

SSIS 2012: Programmatically Create Catalog

Load Integration Services Assembly File Into Visual Studio 2010 Project

Execute Process Task – Compress File Using 7-Zip

Programmatically Create and Deploy SSIS 2012 Project into Catalog Using C#

SOLUTIONS

COMPANY

RESOURCES

LEGAL

+27 11 044 9467

sifiso@selectsifiso.com