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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.