Archive for the ‘VB.NET’ Category

Extract Variable Records to the Same File

January 22, 2010

Hello my faithful reader(s).  I have been away for a while but do not despair:  I am back and 2010 promises some really cool posts.  Today’s post centers on extracting variable record types to a single flat file.  This applies to data warehouse type files that have  header, detail & trailer records somewhat similar to those I have seen for terradata and other warehouse applications.  There will also be a future post in this blog that will describe how to load this data type into your warehouse along with some built in intelligence.

(more…)

Parent-Child records in SSIS

December 1, 2009

Converting a File with Parent-Child Records in SSIS

This article talks about converting a file with Parent-Child records using SSIS.  Parent-child files have a header record (parent) with an undetermined amount of subsequent detail records(child).  The transformation extracts non-blank records, creates a key for each record and splits that record by type and then merges the records back together to create a flattened record with a 1-to-1 relationship. 

Read the article at:

http://www.sqlservercentral.com/articles/SSIS/68409/

Converting an EBCDIC file using SSIS

September 23, 2009

EBCIDC data is an 8-bit character encoded (code page) file used on IBM mainfram operating systems such as z/OS, OS/390, VM and VSE as well as IBM midrange computer operating systems such as OS/400. Unfortunately, SSIS out of the box can handle EBCDIC conversion but cannot handle a straight conversion from EBCDIC codepage (37) to ASCII codepage (1252).

Code Project has a fairly good article on using VB.NET to handle the conversion but here is how to handle and load the files using the SSIS interface.

(more…)