I was trying to run a stored procedure in SSIS and put the results into a table and got this error:
Error at Data Flow Task [Call sp_Get_Activity ]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: “Microsoft OLE DB Driver for SQL Server” Hresult: 0x80004005 Description: “The metadata could not be
determined because statement ‘EXEC (@TSQL) at Production’ in procedure ‘sp_Get_Activity’ contains dynamic SQL.
Consider using the WITH RESULT SETS clause to explicitly describe the result set.”
Keep reading to see how I fixed it!Continue reading SSIS Hresult: 0x80004005 Consider using the WITH RESULT SETS clause to explicitly describe the result set.SSIS Hresult: 0x80004005