How to use Temp tables in DTS Package?

#1

Can you create a temp table in one Execute SQL Task and use it in the query
specified in another Execute SQL Task that is connected to a different
database?

Thanks, Dave.

#2

Local temp tables won't persist across connections, separate
Execute SQL tasks. Global temp tables will work but they can
be a pain to work with. You may also want to consider using
a staging table - like a permanent work table - instead of a
temp table.

-Sue

On Mon, 20 Mar 2006 13:20:30 -0800, Dave
<Dave (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Can you create a temp table in one Execute SQL Task and use it in the query
specified in another Execute SQL Task that is connected to a different
database?

Thanks, Dave.

#3

Sue, thanks you confirmed some things for me. I used a work table in the
past but wasn't sure if that was the best way to go. Dave.

"Sue Hoegemeier" wrote:

Quote:

Local temp tables won't persist across connections, separate
Execute SQL tasks. Global temp tables will work but they can
be a pain to work with. You may also want to consider using
a staging table - like a permanent work table - instead of a
temp table.

-Sue

On Mon, 20 Mar 2006 13:20:30 -0800, Dave
Dave (AT) discussions (DOT) microsoft.com> wrote:

Can you create a temp table in one Execute SQL Task and use it in the query
specified in another Execute SQL Task that is connected to a different
database?

Thanks, Dave.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to use Temp tables in DTS Package?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to use Temp tables in DTS Package? - 03-20-2006 , 03:20 PM

Re: How to use Temp tables in DTS Package? - 03-20-2006 , 10:05 PM

Re: How to use Temp tables in DTS Package? - 03-21-2006 , 09:07 AM