Do you see any blocking on the servers?
Set each ExecutePackage task to execute on the main thread in the workflow
properties.
--
--
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
"miker9999" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi all,
I have a strange issue. I am attempting to execute multiple dts packages
at once using a single dts package containing multiple execute package
|
steps. When executed individually, each of the dts packages runs
successfully. However, when executed together using these execute package
tasks, it always seems to fail midway through, giving the following error:
[DBNETLIB][ConnectionRead (rec()).]General Network Error...