This is my first post ever so yea herewe go... let me say thanks for such an amazing and complete step by step post.

I just came across with this email in my mailbox, just when it is almost time for me to develop a solution like the one you posted. My doubts and limitations rise when im stopped for that medium-sized wall called c#, so i need to keep practicing.

But i also have to achieve this using SSIS 2008 R2. So my question is, is it still possible?

Cheers.