Thanks for the reply. Yeah, I am now using DTExec. Following is the progress on this:

I have the dtsx file and the batch file that calls this dtsx in server1 (that has ssas 2005 and is on 64-bit). Calling this batch using WMIC command from server 2 (SQLServer 2000).

Still have to explore on how to get the DTExec's execution result. As what WMIC does is just spawns the process on server1 and returns with success code and giving the process id.

Any other suggestions/way of doing this.

All I want is, Server 2 does not have the DTExec utility and would want to run the package in Server 1 from the Server 2(with an sql procedure).