Datapump task qustion for temporary and Global temporary table

#1

Hi there,

In DTS, Can we use temporary or global temporary created table in DATA
PUMP TASK for Exporting data from Server1.DB1 to Server2.DB1 ?

Here is case :

In DTS Package.

Create table ##Global(xyz int) on Server2.
Server1 ----- Data Pump Task----->Server2
In Data Pump Task ( My Select Query)
Select xyz from(Server1) ABC and map this
xyz field to ##Global(xyz) on Server 2. Can we do this ?

As I know, In DTS we can only use the Physical table with Data Pump task to
export data from one server to other Server and Vice versa.

Can any one help please ..

Thanks
-Kris

#2

You cannot do this because you can't bind to a temporary table at design
time.

HTH,
Axel Dahmen
www.sportbootcharter.com

--------------
"Kris" <Kris (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:72411B78-B231-4CBB-8C33-DC436BCF7540 (AT) microsoft (DOT) com...

Quote:

Hi there,

In DTS, Can we use temporary or global temporary created table in DATA
PUMP TASK for Exporting data from Server1.DB1 to Server2.DB1 ?

Here is case :

In DTS Package.

Create table ##Global(xyz int) on Server2.
Server1 ----- Data Pump Task----->Server2
In Data Pump Task ( My Select Query)
Select xyz from(Server1) ABC and map this
xyz field to ##Global(xyz) on Server 2. Can we do this ?

As I know, In DTS we can only use the Physical table with Data Pump task
to
export data from one server to other Server and Vice versa.

Can any one help please ..

Thanks
-Kris

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

Datapump task qustion for temporary and Global temporary table

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

Datapump task qustion for temporary and Global temporary table - 03-24-2005 , 05:19 PM

Re: Datapump task qustion for temporary and Global temporary table - 03-26-2005 , 09:54 PM