In line with the advice that we should be using ODBC rather than OLE DB (http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with-odbc-for-native-relational-data-access.aspx) I just began a new project and added a new ODBC Connection Manager. My SQL statement was:
SELECT SomeColumn FROM [SomeSchema].[SomeFunction](?)
and inserting the results into an Object variable. It failed with error:
"Disconnected recordsets are not available from ODBC connections."
This was discovered in Denali RC0
I switched to using an OLE DB Connection Manager (which, by the way, required me to change my parameter name in the Parameter Mapping tab from 1 to 0 - very odd) and everything worked fine.
I presume from this that ODBC Connection Managers don't work properly with SSIS and we should continue to use OLE DB (contravening the advice on the blog post linked to above).