DTS: ActiveX Script task error when using with Analysis Processing Task 
Author Message
 DTS: ActiveX Script task error when using with Analysis Processing Task

I am trying to automate the task of Processing Analysis Services Cubes.
I need to incrementally process my Cubes. Hence I  created a package
with a ActiveX script task and a Analysis Processing Task.
I tried using ActiveX script task to change the properties of a Analysis
Processing Task.

My ActiveX script is like this

Function Main()
         Dim pkg
         Dim task
         Dim props

         Dim RecentYear
         Dim RecentMonth

'I be calculating these two variables. For now I have hardcoded them

        RecentYear = 2003
        RecentMonth = '05'

        Set pkg = DTSGlobalVariables.parent
        Set task = pkg.Tasks("DTSTask_DTSOlapProcess.Task_1")
        Set props = task.Properties

        props("Filter").Value = "Testing .... "  &  RecentYear and  &

        Main = DTSTaskExecResult_Success

End Function

The ActiveX step works fine when I use "Execute Step", but when I use
"Execute Package" - the step fails and giving the following error

" Need to run the object to perform the operation
Code Execution Exception: Exception_Access_Violation "

With some debugging, the could guess that the error is occuring at

        Set task = pkg.Tasks("DTSTask_DTSOlapProcess.Task_1")

I even tried using the example given in BOL. The same error occurs.
Anyone know how to avoid it.

Any other approach for my automation will also be helpful.

Posted via http://www.***.com/

Mon, 07 Nov 2005 16:36:37 GMT
 [ 1 post ] 

 Relevant Pages 

1. DTS: ActiveX Script task error when using with Analysis Processing Task

2. DTS Task Kit 1 OLAP Services Processing Task error

3. dts analysis services processing task error

4. Time out errors when executing DTS ActiveX Script Task (VBScript)

5. call a task by activex script task

6. Passing values between Query Tasks ans ActiveX script tasks

7. ActiveX Script Text box missing from ActiveX Script Task Properties

8. DTS: Create Process Task and Data Driven Query Task properties

9. DTS Task Analysis Services Processing - General ?

10. DTS/Analysis Services Process Task takes to long to run

11. DTS Analysis Services Processing Task

12. Analysis Services Processing Task for DTS

Powered by phpBB® Forum Software