PROBLEM: if you try to execute with a SSIS Data Flow a stored procedure containing a temporary table, you receive this error message:
Exception from HRESULT: 0xC020204A Error at From SQL Server to Excel [OLE DB Source [91]]: SSIS Error Code DTS_E_OLE...