Sounds fine.  I was looing at a possibility of using an 'Execute SQL Task' t oget the distinct results and then based on those results using something like the following.

'**********************************************************************

' ...

Thanks Adrian,

I actually did work it out finally, and the appraoch you suggested was exactly the path that I took.

Thanks all.

As it turned out, all they wanted was to generate the knowledge of what views/stored procs are out of sync. 

so I wrote a nice simple little script as...