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...

Thanks for the suggestion Michal. Casting to string would of course be simple but the SP is widely used elsewhere and I don't want to be changing an output data...

Still no script. Is this what they call vapourware?