Hi,

Can anybody help me with this: -

I have DTS package that processes a cube, I added a Dynamic Properties task
in order to set the TreeKey property of the DTSOlapProcess. When I run the
package I get: -

Need to run the object to perform this operation
code execution exception: EXCEPTION_ACCESS_VIOLATION

I figured that maybe DTSOlapProcess is a bit flaky (remember issues under
v7) so I picked up some sample code from MSDN, namely: -

Set pkg = DTSGlobalVariables.parent
Set task = pkg.Tasks("DTSTask_DTSOlapProcess.Task_1")
Set props = task.Properties
props("ProcessOption").Value = 2
props("Datasource").Value = "FoodMart"
props("FactTable").Value = "sales_fact_1998"

I still get the same error, a bit of judicial comenting out indicates the
line causing the problem is: -
Set props = task.Properties

Does anybody have any ideas? its SP4

Thanks,
Paul

In message <upF3BAS4DHA.2612 (AT) tk2msftngp13 (DOT) phx.gbl>, Paul Smith
<nospam (AT) sagestore (DOT) com> writes

Set the ActiveX Script Task to execute on the main package thread. The
OLAP task is written in VB, and due to the threading limitations of VB
it must be set to execute on the main thread, as must any other task
that "touches" it such as you ActiveX Script, or a Dynamic Properties
Task, or an Execute Package Task that calls a child package which
contains the OLAP task.

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

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks Darren, wasn';t aware that the OLAP task was VB .....

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote