Mea culpa, I overlooked one line in the first response. I'll just go shoot myself now.

Now you're free to criticize Jeff Moden (for whom I have a tremendous amount of respect) for saying he wouldn't do this in SSIS at all.