Why dont you split it out?
What you could do is to query sheet 1 for all the data, and then have a column derivation for DefaultValue.
Therefore, each row passing through the column derivation will have a defaultvalue appended, and it should load to your OLEDB destination quite easily