Michael_Cicogna
asked on
LoadFromSQLServer hangs when loading a Package containing an Analysis Service Processing Task
Hi,
I have a C# application, which is used to start DTS Packages on a Microsoft SQL Server 2000 Service Pack 3. Everithing works fine with "normal" DTS packages, that don't contain any Analysis Steps.
If i add an Analysis Step (Process a Cube) to a packagethe following Command hangs forever:
package.LoadFromSQLServer( ManagerSet tings.DB_H OST,
ManagerSettings.DB_USER, ManagerSettings.DB_PASS,
DTS.DTSSQLServerStorageFla gs.DTSSQLS tgFlag_Def ault, null, null,
null /*id*/, PackageName, ref pVarPersistStgOfHost);
Does anyone have an ideo how to solve my problem?
Thanks for your advice
Michael
I have a C# application, which is used to start DTS Packages on a Microsoft SQL Server 2000 Service Pack 3. Everithing works fine with "normal" DTS packages, that don't contain any Analysis Steps.
If i add an Analysis Step (Process a Cube) to a packagethe following Command hangs forever:
package.LoadFromSQLServer(
ManagerSettings.DB_USER, ManagerSettings.DB_PASS,
DTS.DTSSQLServerStorageFla
null /*id*/, PackageName, ref pVarPersistStgOfHost);
Does anyone have an ideo how to solve my problem?
Thanks for your advice
Michael
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"Thanks anyway"
The above example had the DSO example....Why the low grade????
The above example had the DSO example....Why the low grade????
ASKER
I managed to work around my problem by using an ActiveX Script to Process the Cube.
Dim dsoServer as DSO.Server
Set dsoServer = new DSO.Server
dsoServer.Connect('localho
Dim dsoDb as DSO.MDStore
Set dsoDb = new dsoServer.MDStores("myData
dsoDb.Process processFull
Main = DTSTaskExecResult_Success
End Function
Thanks anyway