I am using a Temporary table in Stored Procedure in SQL Server.
I am trying to use that SP in OLE DB Source Editor.
I can see the data output returned in the Query Builder that comes with Build Query button.
But when I Click the Columns tab, I am getting the below error.
- TITLE: Microsoft Visual Studio
Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code
DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source: "Microsoft SQL
Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid
object name '##Payment'.".
Error at Data Flow Task [OLE DB Source [1]]: Unable to retrieve column
information from the data source. Make sure your target table in the
database is available.
Does that mean I cant use temp tables in SP, if I want it to be consumed by SSIS
Copyright Notice:Content Author:「Jason M」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/1579476/using-temp-tables-in-ssis