Hi All,

I have a dts package (package A) which I can execute from SQL Enterprise
Manager. I then created another dts package (package B) that runs
package A. But, package B hangs when I try to execute it. Even if I hit
the Cancel button on the dts status window it never cancels and I have
to kill the task. When I check the error log for package B I see that it
started but elapsed time is 0 while none of the steps in package A have
been started.

Does anyone know why do I have this problem.

thx,
Kevin


*** Sent via Developersdex http://www.developersdex.com ***

Try setting the execute package task to execute one the main thread. It
could be the same underlying problem as described here-

PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It as
a Scheduled Job
(http://support.microsoft.com/default...b;en-us;318819)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Kevin R." <kamran (AT) riverone (DOT) com> wrote

I really appreciate you taking the time responding to my problem. Your
suggestion worked!

thx,
kr


*** Sent via Developersdex http://www.developersdex.com ***