Thanks again. I don't feel that this approach really addresses my circumstances in a satisfactory way so I'll review my options.

Perhaps I'll develop SSIS wrapper SPs just to get around the problem. More likely I'll simply not use SSIS at all as I have an extensive T-SQL code library that can achieve what I want quickly.