![sql server - Error while using Stored Procedure with dynamic sql in SSIS OLE-DB source - Stack Overflow sql server - Error while using Stored Procedure with dynamic sql in SSIS OLE-DB source - Stack Overflow](https://i.stack.imgur.com/t8yHO.png)
sql server - Error while using Stored Procedure with dynamic sql in SSIS OLE-DB source - Stack Overflow
![SSIS Hresult: 0x80004005 Consider using the WITH RESULT SETS clause to explicitly describe the result set.SSIS Hresult: 0x80004005 – Jim Salasek's SQL Server Blog SSIS Hresult: 0x80004005 Consider using the WITH RESULT SETS clause to explicitly describe the result set.SSIS Hresult: 0x80004005 – Jim Salasek's SQL Server Blog](https://jimsalasek.files.wordpress.com/2022/10/wr_01.jpg?w=923)
SSIS Hresult: 0x80004005 Consider using the WITH RESULT SETS clause to explicitly describe the result set.SSIS Hresult: 0x80004005 – Jim Salasek's SQL Server Blog
![SQL SERVER - Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012 - SQL Authority with Pinal Dave SQL SERVER - Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/execsp.jpg)
SQL SERVER - Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012 - SQL Authority with Pinal Dave
![sql server - Assiging stored procedure results to SSIS variable - Database Administrators Stack Exchange sql server - Assiging stored procedure results to SSIS variable - Database Administrators Stack Exchange](https://i.stack.imgur.com/iAPGb.jpg)