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
Tags: SSIS