• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

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(ManagerSettings.DB_HOST,
      ManagerSettings.DB_USER, ManagerSettings.DB_PASS,
      DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null, null,
      null /*id*/, PackageName, ref pVarPersistStgOfHost);

Does anyone have an ideo how to solve my problem?

Thanks for your advice

Michael
0
Michael_Cicogna
Asked:
Michael_Cicogna
  • 2
1 Solution
 
arbertCommented:
This seems to be a pretty common problem with no "built in" answer--here was a good thread on it:


http://www.developersdex.com/sql/message.asp?p=1252&ID=%3COVEDyVOeEHA.3988%40tk2msftngp13.phx.gbl%3E
0
 
Michael_CicognaAuthor Commented:
Hi all

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('localhost')

      Dim dsoDb as DSO.MDStore
      Set dsoDb = new dsoServer.MDStores("myDataBase")
      
      dsoDb.Process processFull
      Main = DTSTaskExecResult_Success
End Function

Thanks anyway
0
 
arbertCommented:
"Thanks anyway"

The above example had the DSO example....Why the low grade????
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now