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
