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


The information in this article 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:
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

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

Modification Type:MinorLast Reviewed:1/9/2004
Keywords:kbinfo KB282966 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.