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...
SQL Server Database Source Control using VSO Git
read more
Load Integration Services Assembly File Into Visual Studio 2010 Project
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
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
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
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#
Abstract SQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM - Managed Object Model. In this...