Many thanks for both of your replies & opinions. I just didn't want to look past a simpler solution that I wasn't thinking of and overcomplicate things w/SSIS for this.

Based on your replies and other research I've done, I'll recommend to the client that we use SSIS for this upcoming effort. Should be fairly straightforward to develop from what I have in mind conceptually.

Thanks again.