A-Code - BI Software engineering

Paul Siteur, Business Intelligence Software engineer, Consultant working with tools like Microsoft SQL Server, SAS, Cognos, Oracle, C#, Java located in Nijmegen

You are currently browsing the SQL 2005 BI category.

SSIS Combini-export

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…

Tags:

Posted June 3rd, 2008.

Add a comment