hi all !!!

I wrote a ETL package that allows many tasks to run in parallel. I set the
maximum number of tasks to run in parallel to 5.

however, only one single task runs at a time; all other tasks that could be
running in parallel show Status=Started at the Execution Progress window but
they are actually not running.

any insight on this ?

thanks in advance,
Ant.

If the tasks use the same connection object then they are executed
sequentially.

--

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


"Antonio Lopez Arredondo" <adog (AT) someplace (DOT) com> wrote