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:

SQL Server 2012

SQL Server Database Source Control using VSO Git

by Sifiso | Oct 13, 2022 | Database, SQL Server 2012

For a while now, I have ensured that the source code of new projects that I have undertaken (in both contract and permanent employment) is version...

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

Failing to Preview Report in Report Builder

by Sifiso | Oct 13, 2022 | Execute Report Definitions, Permissions, Report Builder, Report Builder 3, Report Manager, SQL Server 2012, SSRS, System Role

Abstract We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for the client's business...

Handling No Data in SSRS Controls

by Sifiso | Oct 13, 2022 | Report Builder, Report Builder 3, Report Manager, SQL Server 2012, SSRS

When SQL Server Reporting Services (SSRS) successfully renders a given report control (i.e. Table, Matrix, List, etc.), the result set can either be...

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

SQL Server 2012

SQL Server Database Source Control using VSO Git

Load Integration Services Assembly File Into Visual Studio 2010 Project

Execute Process Task – Compress File Using 7-Zip

Failing to Preview Report in Report Builder

Handling No Data in SSRS Controls

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

SOLUTIONS

COMPANY

RESOURCES

LEGAL

+27 11 044 9467

sifiso@selectsifiso.com