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

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:

Add a comment


Warning: file_get_contents() [function.file-get-contents]: open_basedir restriction in effect. File(http:) is not within the allowed path(s): (/home/siteur/:/tmp:/var/tmp:/usr/local/lib/php/) in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents(http:) [function.file-get-contents]: failed to open stream: Operation not permitted in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents() [function.file-get-contents]: open_basedir restriction in effect. File(http:) is not within the allowed path(s): (/home/siteur/:/tmp:/var/tmp:/usr/local/lib/php/) in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents(http:) [function.file-get-contents]: failed to open stream: Operation not permitted in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents() [function.file-get-contents]: open_basedir restriction in effect. File(http:) is not within the allowed path(s): (/home/siteur/:/tmp:/var/tmp:/usr/local/lib/php/) in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents(http:) [function.file-get-contents]: failed to open stream: Operation not permitted in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents() [function.file-get-contents]: open_basedir restriction in effect. File(http:) is not within the allowed path(s): (/home/siteur/:/tmp:/var/tmp:/usr/local/lib/php/) in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents(http:) [function.file-get-contents]: failed to open stream: Operation not permitted in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents() [function.file-get-contents]: open_basedir restriction in effect. File(http:) is not within the allowed path(s): (/home/siteur/:/tmp:/var/tmp:/usr/local/lib/php/) in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97

Warning: file_get_contents(http:) [function.file-get-contents]: failed to open stream: Operation not permitted in /home/siteur/domains/paulsiteur.nl/public_html/wp-includes/class-feed.php on line 97