SSIS: OLE DB Source object can't read columns of a EXEC SP that contains temp tables (Hash Table?)
Posted on 2008-06-23
SSIS - I am trying to insert the results of a ole db source/stored proc, into a ole db destination/table.
In the ole db source object, Connection Manager, I have SQL Command/ my SP typed out, and hitting the 'Preview' button shows the returned recordset as expected.
Problem: In the ole db source object, Columns, no columns are visible.
I have heard that this may be because I am using temp tables in my SP, that I have to replace them with 'hash tables', but I am not familar with these.
Question: Does using temp tables cause problems in DTS/SSIS?
Thanks in advance.