INF: Analysis Services Processing Task May Not Execute Correctly (296533)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 2000 Analysis Services

This article was previously published under Q296533

SYMPTOMS

The Analysis Services Processing Task of Data Transformation Services (DTS) may not execute correctly if another DTS package executes the DTS package that contains the Analysis Processing Task by using the Execute Package task. In this case, not only is the Analysis Services Processing task not executed, the Execute Package task may also not finish.

CAUSE

The Analysis Services Processing task is the apartment threading model, not the free threading model. Therefore, in order to execute the Analysis Services Processing task, it must be executed on the main package thread.

WORKAROUND

Execute the Execute Package task on the main package thread.

MORE INFORMATION

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

242391 INF: DTS Package Development, Deployment and Performance

282966 DTS Package Fails with Dynamic Properties Task and OLAP Processing Task


Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbprb KB296533