<div>
SET FMT ONLY OFF<br />
SET NOCOUNT ON<br />
EXECUTE sp_ProcName<br />
<br />
or you can add it directly in your procedure<br />

</div>


SET FMT ONLY OFF
SET NOCOUNT ON
EXECUTE sp_ProcName

or you can add it directly in your procedure


<div>
&gt;SET NOCOUNT ON<br />
Already had it.<br />
<br />
&gt;SET FMTONLY OFF<br />
Wowwie, that works great. &nbsp;Thanks.
</div>


>SET NOCOUNT ON
Already had it.

>SET FMTONLY OFF
Wowwie, that works great.  Thanks.

<div>
I had the same problem a week ago. So yeah, i know how you feel =)
</div>


I had the same problem a week ago. So yeah, i know how you feel =)

<div>
Hi,<br />
<br />
I think using of table variables will solve the issue.<br />
<br />
So &nbsp;replace the temp tables with table variables. (replace #temp table with @table variable)<br />
<br />
all the best.<br />
<br />

</div>


Hi,

I think using of table variables will solve the issue.

So  replace the temp tables with table variables. (replace #temp table with @table variable)

all the best.



<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
SSIS - I am trying to insert the results of a ole db source/stored proc, into a ole db destination/table. <br />
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. <br />
<br />
Problem: &nbsp;In the ole db source object, Columns, no columns are visible. &nbsp;<br />
<br />
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.<br />
<br />
Question: &nbsp;Does using temp tables cause problems in DTS/SSIS? &nbsp;<br />
<br />
Thanks in advance.<br />
Jim<br />

</div>
</div>


Hi All

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.
Jim


SSIS:  OLE DB Source object can't read columns of a EXEC SP that contains temp tables (Hash Table?)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.