executing dts with cube process from ASP.NET -
03-07-2006
, 07:18 PM
hi
i have a dts with analysis service process task. it works fine when i run it
in enterprise manager.
i made a console app loading dtspkg and executing. it's good, too.
(i read http://www.sqldev.net/dts/ExecutePac...isual%20Csharp)
lastly, i made a web app works in same way as console app i've already
tested but it didn't worked. when it starts LoadFromSQLServer method, it
never returns. never stop.
for a test, i took off cube process taks from dts pkg, and ran the web app.
it worked fine.
but if i put the cube process taks back into dts pkg, it never returns.
has anyone experienced something like this?
what should i try to make it work?
any piece of advice is greatly appreciated. |