DTS package with cube builder task

• lourem

  SSC Rookie

  Points: 44

  More actions

  August 31, 2003 at 8:08 pm

  #151918

  Hi there

  I am trying to do process a dts package that has cube processing task in it. However when I try to use the Package2.LoadFromSqlServer method from the VB script, I got the following error:

  *****

  The execution of the following DTS Package failed:

  Error Source: Analysis Services Processing Task

  Error Description:Invalid processing option

  Error code: 8004021D

  \Error Help File:

  Error Help Context ID:1000440

  ****

  All the other packages(non cube processing ) have run successfully loaded other packages.

  Is there any tricky with cube builder ??

  This in the VB script I'm using.

  ***

  Function Main()

  Main = DTSTaskExecResult_Success

  Dim oPkg, oStep

  Dim sServer, sUID, sPWD, iSecurity , sPkgPWD, sPkgName, sErrMsg,vResultCode

  if DTSGlobalVariables("gTriggerFound").Value = "Yes" then

  ' RunPackage "ESC_LOGISTICS_FACT_ORD_DAILY"

  msgbox "both triggers found"

  else

  ' msgbox "NOT Run package"

  DTSGlobalVariables("gTriggerFound").Value = "No"

  end if

  ' msgbox DTSGlobalVariables("gTriggerFound").Value

  Main = DTSTaskExecResult_Success

  End Function

  Function RunPackage(vPkgName)

  Set oPkg = CreateObject("DTS.Package")

  oPKG.LoadFromSQLServer "cpcusskreportdv", , , DTSSQLStgFlag_UseTrustedConnection, , , ,vPkgName

  oPKG.execute

  oPKG.UnInitialize

  Set oPKG = Nothing

  End Function

  Any help would be very appreciated.

  Thanks

  Lou

• mhweiss

  SSCarpal Tunnel

  Points: 4284

  More actions

  September 2, 2003 at 8:59 am

  #472205

  In the workflow properties for your cube processing task, is the "Execute On Main Thread" option checked? Doese the task work fine when you execute it directly from within the DTS Designer window?

  Michael

  Michael Weiss

  
  Michael Weiss

• lourem

  SSC Rookie

  Points: 44

  More actions

  September 2, 2003 at 11:39 am

  #472234

  HI Michael.

  Thanks a lot for your help.

  The 'Execute On Main Thread" option is not checked.

  It didn't work either when i tried to execute from DTS Designer window.

  That's why I thought since the Analysis service task is a different object, the LoadFromSqlServer method should not work like for any other package.

  Thanks

  Lou