This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
COURSE of the MONTH
9 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
LoadFromSQLServer hangs when loading a Package containing an Analysis Service Processing Task
Posted on 2004-08-19
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_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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
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
http://www.developersdex.com/sql/message.asp?p=1252&ID=%3COVEDyVOeEHA.3988%40tk2msftngp13.phx.gbl%3E
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('localho
Dim dsoDb as DSO.MDStore
Set dsoDb = new dsoServer.MDStores("myData
dsoDb.Process processFull
Main = DTSTaskExecResult_Success
End Function
Thanks anyway
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month9 days, 4 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.