SQL2000 SP3 (DTS) has a custom task which allows for the
automation of incremental update of OLAP cubes. If this
is paired with a 'Dynamic Property' task on a 'fact'
table which has a key field which is a incremented txn
id - then you have a nice solution for scheduling a
regular drip feed to the cube ... or so I thought.

An MSDN KB article descript how these 2 features don't
work together (because the 'Analysis Task' is not 'free
threading'. This was reported in April 2003 - and is
still not addressed.

My wish list entry is to be able to modify the enhance
the ''Analysis Processing Task' so that a filter can be
assigned via a global variable rather than just a text
field typed at design time.

Execute DTS Package within enterprise manager, and get
error :

Need to run the object to perform this operation

Code execution exception: EXCEPTION_ACCESS_VIOLATION

This happens on a simple DTS package. The error occurs on
the first task (as Dynamic Properties Task). It tries to
assign the 'filter' property of an 'Analysis Processing
Task' (e.g. OLAP Analysis Services, incremental update of
a cube) from a Global variable (a string called 'filter').

However - If I execute this task - it works. It's just
when I execute the 'package' when I get the error.