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:35:39 GMT
 DTS: ActiveX Script task error when using with Analysis Processing Task

Hi
Make sure that the Task is executed on the main package thread rather
than on a spawned thread.

Right mourse click DTS task
Select WORLFLOW  ---> then WORKFLOW PROPERTIES
click 2nd tab page "Options"
Check Execute on main package thread.

Quote:

> 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.



Mon, 07 Nov 2005 22:10:07 GMT
 
 [ 2 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-Analysis Service Processing Task

10. DTS Analysis Services Processing Task

11. DTS Task Analysis Services Processing - General ?

12. Execute DTS (Analysis Services Process task ) from the store procedure


 
Powered by phpBB® Forum Software