<div>
Global temporary tables are deleted when all users referencing the table disconnect from Microsoft SQL Server. &nbsp;I'm not sure if this is your problem or not. &nbsp;Why not try using a regular table and deleting it manually?
</div>


Global temporary tables are deleted when all users referencing the table disconnect from Microsoft SQL Server.  I'm not sure if this is your problem or not.  Why not try using a regular table and deleting it manually?

<div>
Edit: of course, by manually I meant by manually adding a line of code to do it automatically...
</div>


Edit: of course, by manually I meant by manually adding a line of code to do it automatically...

<div>
Hi,<br />
<br />
Yeah, that is my option. &nbsp;The issue would be that the table has to continue to exist (ie. I would truncate it and not drop it) so that the next OLE DB SQL would correctly compile.<br />
<br />
Todd<br />

</div>


Hi,

Yeah, that is my option.  The issue would be that the table has to continue to exist (ie. I would truncate it and not drop it) so that the next OLE DB SQL would correctly compile.

Todd


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'd like to create a #Temp table as part of join in a SQL statement in a OLE DB Source task step. &nbsp;I keep getting an error as the # temp is not available at the time I build the new SQL OLE DB Source. &nbsp;<br />
<br />
I've tried ## temp tables and had no luck setting a SQL Task to use Full Result Set.<br />
<br />
Any thoughts?<br />
<br />
Thanks,<br />
Todd<br />

</div>
</div>


Hi,

I'd like to create a #Temp table as part of join in a SQL statement in a OLE DB Source task step.  I keep getting an error as the # temp is not available at the time I build the new SQL OLE DB Source.  

I've tried ## temp tables and had no luck setting a SQL Task to use Full Result Set.

Any thoughts?

Thanks,
Todd


How can you use a #temp table from one SSIS task in another task step?

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.