SSIS: First Time Script Component

Hello,

I have a flat file that contains detail in each record as indicated below:


HEADER_ID, ATTRIB_A(1..10), ATTRIB_B(1..10), ATTRIB_C(1..10), etc.

The index of the attribute relates it to other attributes with the same index. It needs to look like this in the detail table:


HEADER_ID, ATTRIB_A1, ATTRIB_B1, ATTRIB_C1

HEADER_ID, ATTRIB_A2, ATTRIB_B2, ATTRIB_C2

I need to pivot these attributes into a detail table that relates back to the header information. Because of the number of these, I don't want to use the UNPIVOT Task because there are so many. I was hoping to move the complexity to a Script Component where I could read one line and transform it to a normalized state.

Can someone point me in the right direction?

Thanks.