ETL Checklist

The content of this article is based on the experience I gained in a big data warehouse project. My initial intent writing this article is to provide a good starting point for other DWH projects where one have to design and build ETL processes. In the first chapter I am writing about the data sources…

1

SSIS – Programmatically connect DataFlow components

In this part of my series of blogs about dynamically modifying SSIS Packages I describe how to use the SSIS programming API to create and connect data flow components. DataFlow Components have input or/and output column collections depending on the type of component. Components like DataSources do not have an input collection whilst destination component…


Move an ASP.NET application to the cloud

 This is a step by step guide to move an existing ASP.NET Web Application to the Cloud.  Add a cloud service project to your existing solution Solution Explorer right click your solution and select ‘Add -> New project …’ In the Add New Project dialog select Installed Templates –> Cloud -> Windows Azure Project template…


SSIS – programmatically add an aggregate component

Intro In this part of my series of blogs about dynamically modifying SSIS Packages I describe how to programmatically add or modify an Aggregate component. Sample The following code snippet shows how to add and modify an aggregate component by implementing the following steps 1. Add a new aggregate component to a data flow tasks.2….