December 1, 2004 at 5:29 am
Hi
I am having a problem executing a small DTS package from within another Local Package in Enterprise Manager in SQL Server 2000. I am using the 'Execute Package Task' from the toolbar. Other small packages execute from within the umbrella package fine. The problem package returns the error message: 'Execution was cancelled by user'??
I have created a new Local Package and tried to execute this one package from within. I get the same error message.
The problem package executes fine on its own, but from within another package - no go.
I hope someone can help.
Paul
December 1, 2004 at 2:55 pm
I don't know what your package is trying to do, but I didn't have any problem when executing within another package.
December 2, 2004 at 9:19 am
If you haven't already, turn on package logging for the child package. Also turn on logging for each Transform Data task or Data Driven Query task that you may have in the package. You may get more clues about what is going wrong.
It's possible that the parent package is trying to execute the wrong version of the child package. When you specify the child package in the Execute Package task, select just the package name rather than a version.
Greg
Greg
December 2, 2004 at 9:57 am
Thanks for the replies.
Greg, I have chosen to execute the Package Name - so that, I guess, is not the problem. How do I turn on logging for the child package? I presume this will point me at why it is returning 'Execution was cancelled by user'??
I am very grateful for your help.
Paul
December 2, 2004 at 10:09 am
Open the child package in DTS Designer, open Package Properties dialog, select the Logging tab, enter the name of an error file in the "Error handling" section.
Hopefully, you'll get a clue from the error log.
Greg
December 3, 2004 at 5:25 am
Hi Greg
Will do. Many thanks for all your help.
Paul
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply