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  &
        RecentMonth

        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