Microsoft KB Archive/296533

= INF: Analysis Services Processing Task May Not Execute Correctly =

Article ID: 296533

Article Last Modified on 2/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * 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

Keywords: kbprb KB296533

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.