I am trying to execute 5 Transform Data tasks in parallel
from an Oracle source to a SQL Server destination. Are
seperate source and destination connections required to
have them go in parallel?

Also, after I create seperate source and destination
connections for each task, I also increased the number of
tasks allowed to go in parallel in the Package Properties.
I have this set to 8 tasks in parallel. However, only two
tasks seem to be running at the same time. Why might this
be?

Thanks.

All that will happen is you will see a lot of context switches on the
processor. The tasks will start but they will not nessarily have any
processor time. I set the values of these two properties to
COUNT(Processors).

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sue" <anonymous (AT) discussions (DOT) microsoft.com> wrote