Microsoft KB Archive/282966

= DTS Package Fails with Dynamic Properties Task and OLAP Processing Task =

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:

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.

