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

Continue reading ‘SSIS Combini-export’