Hi,

Did anybody get back to you on this one ?

I am having exactly the same trouble.

Cheers !

Parul


--
Posted via http://dbforums.com

In article <3469547.1066090131 (AT) dbforums (DOT) com>, bhandp
<member42952 (AT) dbforums (DOT) com> writes
Have you tried setting the Close Connection On Completion option under
Workflow Properties of the task. (Right-click the icon).

If you are still having problems can you remind us what the problem is
as I have lost the threading on this one.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hi Darren,

Thanks for writing back. No I have not tried the 'Close Connection On
Completion' Option.

Question is, where do I find this option, as its the datapump that looks
at the old connection.



Location of my thread:
http://www.dbforums.com/showthread.p...45#post3482345



Thanks for your time and help.

-Parul


--
Posted via http://dbforums.com

Thanks Darren,

It worked ! I managed to find the option, in workflow properties "Close
Connection on Completion" and its all working now.

Cheers and thanks for your help.

-Parul


--
Posted via http://dbforums.com