Kategorien
SQL Server

Working with Flat Files in SSIS – Extended Editor

In my experience working with flat files in Microsoft Integration Services can be quite cumbersome sometimes. There are numerous swtiches and options that can be configured to smoothly load CSV files into your database. Configuring things the wrong way may cause your ETL process to crash in case a CSV file changes its structure or […]

Kategorien
.net SQL Server

Delta Loading a Table with SqlDeltaGenerator

In my previous Post I did describe what needs to be considered to implement a fast and stable delta load process. In this post I am going to introduce a tool that will help you to implement such a process within a couple of minutes. The SqlDeltaGenerator is basically a wizard that will create all the […]

Kategorien
.net SQL Server

How to implement a stable delta load process

This article describes two different approaches for loading data from a source system into a staging area of a Business Intelligence system. Full Load and Delta Load. Both approaches can be used to load a table like structure like below from either a database table, a CSV file or a Web Service into a staging table. […]

Kategorien
SQL Server

Installing Adventure Works 2012 for Analysis Services

I recently had some trouble while installing Microsoft demo database „AdventureWorks“. I will sum up briefly what exactly went wrong and how to work around it. First question was what exactly needed to be downloaded. So go to Codeplex  and download AdventureWorksDW2012 Data File and also AdventureWorks Multidimensional Models SQL Server 2012 The Data File is the SQL Server […]