It's amazing what randomly changing things does.

It seems that because I had a result set as singleRow it was expecting a dataset to come back , and it does not...

Hi,

Thanks for the suggestion

Unfortunately, it has made no difference. Still the same error getting returned in SSIS when I try to run it.