In article <OJ4BqGNQDHA.3192 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Rea Peleg
<reapeleg (AT) barak-online (DOT) net> writes

The OLAP processing task is written in VB. VB is not free threaded like
DTS. The OLAP processing task will have been set to execute on main
thread by the designer, but you must also set this for any other task
such as the Dynamic Properties, or ActiveX Script that "touches" the
OLAP task.

Right-click the, Workflow Properties, Execute On Main Thread.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Hello everybody
I want a dynamic properties task to set the treekey property of an olap
processing task
to one of its partitions.
From some reason this wont work and I always get the following massage:
error: "-2147221499 Exception_Access_Violation. Need to run the object to
perform this operation."
Now the funny thing is that if I run each of these steps individually they
both succeed..
The problem appears when I try to execute the package..
This problem seems to be unique to the olap processing task.
If I replace it with some other task its ok.
I'm an administrator on that computer and have full access rights to every
thing (I assume).
It doesn't matter if I address a newly created partition (from a previous
step)
or try to reprocess an old one, which had already been processed.
Thanks for your attention
Rea

Thanks alot
You are right!!!

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:YtDCSOO7L0A$EwlE (AT) sqldts (DOT) com...