How to use temporary tables In the OLEDB Source?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geri Reshef âøé øùó - 18 Mar 2008 08:07 GMT

I want to do such a thing:

Select * Into #T1 From..
Select * Into #T2 From
Select * From .. Inner Join #T1 ... Inner Join #T2 ...

The last Select will be the OLEDB Source.
I don't want to use LookUp objects,
and failed using the 3 Selects in the OLEDB Source object.
How could I do it?

Reply to this Message

jhofmeyr@googlemail.com - 18 Mar 2008 14:18 GMT

On Mar 18, 7:07 am, "Geri Reshef âøé øùó" <GeriRes...@GMail.com>
wrote:

> I want to do such a thing:
>
[quoted text clipped - 6 lines]
> and failed using the 3 Selects in the OLEDB Source object.
> How could I do it?

Hi Geri,

Why do you want to use temp tables and not join on the original source
tables? Are you doing these SELECT INTO's in a stored procedure?

The short answer to your question is that SSIS doesn't like temp
tables (you can get it to use them, but it may result in your
statement being run 5x on the server). The recommended workaround is
to use table variables and INSERT INTO instead of SELECT INTO.

Good Luck!
J

Reply to this Message