DTS Package with Dynamic Properties running Analysis Services Processing

Hot Topic

SQL Server Reporting Services
connection strings for "create database" queries
Using Custom Code
Inconsistand execution of SISS Package
Migration from Cognos ...
Can't connect to Report Server via Management Studio
How to stop discovery from adomd.net connection
Session Time out
Deos SQL server have any setting like nls_length_semantics in Oracle
xmldp diagnostics?

SQL Server

Programmatically Accessing Report Item Properties
DateTime Error
Why you can't set up in 'disabled status' a task in Data Flow layer???
export to PDF showing solid black images - RESOLUTION
sql 2000 tables export
AddEvent, CreateSubscription, and UpdateActiveSubscription guidance
Enterprise Or Express Edition?
display string having length greater than 255
Indexed View - has no influence on performance
sp_dropsubscription, article

DTS Package with Dynamic Properties running Analysis Services Processing

Hi,

I wasn't sure of the location of this as it spans quite a few areas.

I have created a DTS package with Dynamic Parameters. The package is going to process the Dimensions of a cube therefore I have a dynamic property :

DimFolder -> String -> myServer\myCube\DimFolder

Which sets the TreeKey of the Analysis Services Processing Task to set the DimFolder to the correct server.

When I click on the parameters task and run is it works fine. If I then click on all the individual tasks within the DTS they all work fine as well.

However, when I click the play button to run the whole package is one go, I get

"Need to run the object to perform this operations. Code execution exception: EXCEPTION_ACCESS_VIOLATION".

I can't understand how this can happen as clicking each individual task and running each individual task works fine.

Any suggestions...

Jayne

Answer this question

DTS Package with Dynamic Properties running Analysis Services Processing

  • Smriti

    Also you may find that you have to use a scripting task rather than the dynamic properties task. Because of some binding issues I found when I was writing SSABI that I had to use a script task and walk the object model by-hand --- that the dynamic properties task returned errors , even when it was set to run on the main thread. You mileage may vary, but if the main thread setting doesn't work, try using a script task.

    _-_-_ Dave



  • jpopp

    Hi Jayne,

    You may be encountering the problem described below, so try setting the Workflow Poperties of the Dynamic Properties task to "Execute on Main Thread":

    http://support.microsoft.com/default.aspx scid=kb;en-us;282966

    >>

    DTS Package Fails with Dynamic Properties Task and OLAP Processing Task

    View products that this article applies to.
    Article ID : 282966
    Last Review : January 9, 2004
    Revision : 2.1
    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.

    >>



  • DTS Package with Dynamic Properties running Analysis Services Processing
Answer this question