Have you set the connection to "Close connection on completion" in the
workflow for the DataPump?
Righ click the DataPump task | Workflow Properties | Options
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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
"mklapp" <mklapp (AT) zippy (DOT) com> wrote
Quote:
Hello,
We are assembling and testing a DTS package. Some of the connections
are connections to text files. More often than not, we get an error message
|
telling us a task cannot be run because that connection is in use by another
task and cannot be closed or reused.
Quote:
I changed the execution to strictly sequential (no parallel steps), but
I still get the message.
Any Ideas?
|
Re: Connection in use by another task -
05-12-2004
, 08:19 AM
Linear Mode
