Hi all,
I am new of the group and I hope that you can help me to resolve the
"problem" that plagues me...
I must unload the data of many tables (... some of which rather
large...)
from 4 DB ORACLE on my SQL Server 2005...
I have created therefore 4 linked server on my SQLServer that is
connected to the 4 DB Oracle... Then I have created some task (using
SSIS) that they execute one banal instruction of
SELECT * INTO NomeTabella FROM LinkedServer. Schema.NomeTabe llaOracle
where NomeTabella represents my physical table.
Executing then all the task at the same time I see that the task
effectively all are activated entirety, but...
when I try to verify as they come executed the operations, I see that
several SELECT INTO come executed one after the other and NOT in
parallel...
Also watching the data traffic on the net I see that the tables come
tried, created and filled up one for time and NOT in parallel...
Exists a way in order to execute in parallel the instructions of
SELECT INTO?
My Server is bi - processor.
Unfortunately I cannot use the dataflow task of the SSIS because
these
SELECT INTO come shaped in dynamic way (what that I succeed to make
only creating "by hand" SQL instruction).
Bye and thanks !
umboZ
I am new of the group and I hope that you can help me to resolve the
"problem" that plagues me...
I must unload the data of many tables (... some of which rather
large...)
from 4 DB ORACLE on my SQL Server 2005...
I have created therefore 4 linked server on my SQLServer that is
connected to the 4 DB Oracle... Then I have created some task (using
SSIS) that they execute one banal instruction of
SELECT * INTO NomeTabella FROM LinkedServer. Schema.NomeTabe llaOracle
where NomeTabella represents my physical table.
Executing then all the task at the same time I see that the task
effectively all are activated entirety, but...
when I try to verify as they come executed the operations, I see that
several SELECT INTO come executed one after the other and NOT in
parallel...
Also watching the data traffic on the net I see that the tables come
tried, created and filled up one for time and NOT in parallel...
Exists a way in order to execute in parallel the instructions of
SELECT INTO?
My Server is bi - processor.
Unfortunately I cannot use the dataflow task of the SSIS because
these
SELECT INTO come shaped in dynamic way (what that I succeed to make
only creating "by hand" SQL instruction).
Bye and thanks !
umboZ