Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS package with cube processing task

Author  Topic  lourem Starting Member 1 Post Posted - 2003-09-01 : 09:49:37 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. Is there any tricky with cube builder ?? This is 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