Re: Multiple Select Into


The server is bi-processor


On 1 Mar, 15:42, "Steve" <morrisz...@xxxxxxxxxxx> wrote:
On Mar 1, 6:21 am, kaba...@xxxxxxxxx wrote:





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?

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

How many processors do you have available for parallel execution?- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -


.

Relevant Pages

  • [VulnWatch] IA WebMail Server 3.x Buffer Overflow Vulnerability
    ... IA WebMail Server 3.x Buffer Overflow Vulnerability ... the execution of a 'retn' instruction. ... It is also possible to execute a fairly large amount of code ...
    (VulnWatch)
  • Re: File Upload - Security Issues
    ... uploaded and the user could upload any or all of these in theory. ... There is no one product that can give you 100% security, ... > Code doesn't execute in local memory space unless remote user has rights ... > You don't have MS Office installed on the server. ...
    (microsoft.public.scripting.vbscript)
  • Re: programming language
    ... you will find the source code to my bf interpreter. ... instruction_pointer is the index of the instruction currently being executed in the instruction array. ... execute() is where the action happens. ... executegets a pointer to a bf_vm, where it executes one instruction, increments the instruction pointer of the bf_vm so that it points to the next instruction (or does a loop), and returns. ...
    (comp.programming)
  • Re: System.Security.SecurityException was unhandled
    ... Is it a must that I need to register the COM server to the machine using ... CAS permissions on the client machine, and the COM issue is a new problem. ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)