Experts Exchange connects you with the people and services you need so you can get back to work.

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

Michael_Cicogna

Asked: 2004-08-19

Advertise Here

Microsoft SQL Server

1 Solution

LVL 34

arbertCommented: 2004-08-19

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

LVL 2

Michael_CicognaAuthor Commented: 2004-08-20

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

LVL 34

arbertCommented: 2004-08-20

"Thanks anyway"

The above example had the DSO example....Why the low grade????

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.

LoadFromSQLServer hangs when loading a Package containing an Analysis Service Processing Task

Join & Write a Comment Already a member? Login.

Featured Post