Normalized flat file as a source in SSIS

Normalized flat file as a source in SSIS

Post by sv389 » Thu, 27 Jul 2006 04:49:00


Hi,

My source flat file looks like as below:

T1Transaction Header
T2 Insured Details
T3 Policy Details
T2 Insured Details
T2 Co-insured Details
T3 Policy Details
T9 Transaction Trailer

Desired output record is combination of T1, T2 and T3 details. I think
I can conditionally split the file and join them as a single record but
only issue with that is T2 transaction can occur multiple times as
shown above. Apart from this is there any other best way in SSIS to
handle such scenario?

Thanks & Regards,
 
 
 

Normalized flat file as a source in SSIS

Post by sv389 » Thu, 27 Jul 2006 04:53:04

Hi,

My source flat file looks like as below:

T1Transaction Header
T2 Insured Details
T3 Policy Details
T2 Insured Details
T2 Co-insured Details
T3 Policy Details
T9 Transaction Trailer

Desired output record is combination of T1, T2 and T3 details. I think
I can conditionally split the file and join them as a single record but
only issue with that is T2 transaction can occur multiple times as
shown above. Apart from this is there any other best way in SSIS to
handle such scenario?

Thanks & Regards,