I wantend to use a stored procedure into a OLE DB Source, but this appeared not to work, with an error in SSIS “No Column information was returned by the sql Command” hmm, strange.
Thanks to the SSIS junkie blog i found an answer in the comments, it appears you to put
SET FMTONLY OFF
SET NOCOUNT ON
In the top of your sproc, SSIS then finds the necessary metadata to pass the columns of your result to SSIS.