Glad that helped.

I think that's a major limitation within SSIS. Row by row transformations with large amounts of data are not uncommon.