Here I will describe a little data cleaning case using Microsoft SQL Server Integrated Services 2005 for the solution.

Problem

Had to convert a Interbase Address database (called Combini) to an Apple Mac Address program. Problem was all the text fields in the original database had to be merged to one large text block for the Mac Address program.

Solution

SSIS from SQL Server 2005 to convert, merge and create a CSV file. This CSV could be read by a Mac conversion program to prepare it for the Mac Address program.

SQL Server Integrated Services Solution

The datasource connected to the Interbase Server database table “Adressen”

Conversion of the BLOB fields to Unicode Strings

A Script component will be used to do the merging job (combining all BLOB filed-data into one field).

Tree input field, one output

The Sourcecode

Combine the newly created field “AlleAantekeningen” with the others.

The SSIS project running, processing 1716 records.

The resulting CSV file, to be used by the Mac Address book converter program…