471,066 Members | 1,246 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

Parallel Operation

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.NomeTabellaOracle
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

Mar 2 '07 #1
0 1051

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Michael Schmitt | last post: by
11 posts views Thread by karan | last post: by
3 posts views Thread by suvam | last post: by
6 posts views Thread by Abandoned | last post: by
1 post views Thread by Gianni Mariani | last post: by
reply views Thread by Jim Kennedy | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.