Article ID: 282966 - Last Review: November 21, 2006 - Revision: 2.2

DTS Package Fails with Dynamic Properties Task and OLAP Processing Task

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q282966
Expand all | Collapse all

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:
1 task(s) failed during execution
When you double-click the failed Dynamic Properties Task, the following error dialog is displayed:
Code execution exception: EXCEPTION_ACCESS_VIOLATION
Back to the top

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.
Back to the top

WORKAROUND

Execute the Execute Package task on the main package thread.
Back to the top

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
242391  (http://support.microsoft.com/kb/242391/EN-US/ ) INF: DTS Package Development, Deployment and Performance
296533  (http://support.microsoft.com/kb/296533/EN-US/ ) INF: Analysis Services Processing Task May Not Execute Correctly
Back to the top
APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
Back to the top
Keywords: 
kbinfo KB282966
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top