-
DTS - execution cancelled by user
(SQL Server 2000 Enterprise edition on Windows 2003 Enterprise server) When running an 'execute package task' from a package, it errors out with 'execution cancelled by user'. I've tried recreating the 'execute package task' and also recreating the package the task is calling and still get this error. The main package has a number of 'execute package tasks' that it performs successfully. Can anyone give me some hints as to where to look or what to change to get this to work?
Thanks!
-
Trace it in profiler to see what happens. What those tasks do by the way?
-
Open the packages in designer change properties to write a log file. Log file may provide you more descriptive error message.
Also when you run it, it should tell you which step failed. You can open the packages in dts designer and try to run particular step.
-
The profiler trace helped me figure out the problem. Thanks for that suggestion!
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|