Before we go down the SSIS path, I just want to verify that Data Driven Subscriptions are not an option for you, because it seems like that should be your first choice for this. Otherwise, you are going to be calling the Report Services web service from SSIS.