Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unhappy Unanswered: Analysis Services Processing Task hanging up DTS Package execution


    I am trying to run a multi-package ETL process where I execute the top level package which contains a few "Execute Package Tasks". Control is returned to the top level package each time except for the package which contains a "Analysis Services Processing Task" - when I remove this task, everything works just fine. Is there a bug here or am I just missing something?



  2. #2
    Join Date
    Apr 2002
    I encountered the exact same thing. It has something to do with different 'threading models'. The workaround is that you have to make sure that the the task 'runs in the main thread'.
    This is an option within the task in DTS that is not selected by default.
    I don't know exactly which tab it is now, bt you should be able to find it in either the props or the advanced props of the task.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts