Dear Employer,
This task will take at least 3 hours to configure and debug to a point with no errors.
I will be happy to do it and share later via Webex or any other conference software that allows control of the screen, but prior, I would like to understand which query you would like to run for each row and how would you like to save the results of the query.
I am very well versed in SSIS (I run a company that extends SSIS) -however, yours is not a run of the mill, so needs some configuration and debugging.
Cheers, Virginia