Hi MM
The error occurs when you use the proc in an OLEDB Source, within a data flow. ExecuteSQL tasks are not affected, as far as I know.
I did this, using your proc. Then, after clicking on 'Columns', the meta data error is displayed, as per the attached screen shot.