Article ID: 282966
Article Last Modified on 11/21/2006
APPLIES TO
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q282966
SYMPTOMS
When you process a Data Transformation Services (DTS) package that contains both a Dynamic Properties task and an OLAP Processing task, the DTS package may fail during execution of the Dynamic Properties task with the following error message:
When you double-click the failed Dynamic Properties Task, the following error dialog is displayed:
CAUSE
The Dynamic Property task is used to set properties on other tasks, and the Analysis Services/OLAP processing task is a Single Threaded Apartment (STA) component. When the Dynamic Property task tries to set the properties on the STA based component, the Dynamic Property task must run on the main thread to set the properties of the STA based task.
WORKAROUND
Execute the Execute Package task on the main package thread.
REFERENCES
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
242391 INF: DTS Package Development, Deployment and Performance
296533 INF: Analysis Services Processing Task May Not Execute Correctly
Additional query words: DTS Dynamic Properties
Keywords: kbinfo KB282966