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/
Tags: Header Detail, Parent Child Records, SSIS, VB.NET
July 18, 2011 at 11:08 pm |
[...] – Supports loading of files with multiple row formats. I wrote about this in my post: Parent-Child records in SSIS. I guess I’ll have to edit that [...]