dbTalk Databases Forums  

loadfromsqlserver hangs in execution

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss loadfromsqlserver hangs in execution in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mariano
 
Posts: n/a

Default loadfromsqlserver hangs in execution - 12-21-2004 , 02:42 AM






Hi, I try to load in a .net web application a DTS Package containing
Analysis Services Task, which simply reprocesses a cube.
But the "LoadFromSQLServer" command hangs before retrieving the Package
information. In other words it remains waiting to infinite before it goes on
with the executing.
For other DTS Packages the "LoadFromSQLServer" command is working fine.

this is my schenario:
server with SQLServer 2000, IIS 5, Analisys services and .Net framework 1.1



Thanks for help.



Reply With Quote
  #2  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default RE: loadfromsqlserver hangs in execution - 01-03-2005 , 06:11 AM






Hi,

Did you set the Workflow Property, "Execute on main package thread" option
for the Transform Data task?

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.