Hi Mike,

Recently I have implemented similar thing with SSAS 2005, using the blog below. Hope this helps

http://bigorakine.spaces.live.com/Blog/cns!1F5DBA5FD9A2BA1C!253.entry?wa=wsignin1.0&sa=43987991

Hi ,

It's been time I been through this post. Have you found solution for this problem. I'm also trying to connect to similar web service throught SQL server 2005. I...

Hi Jose,

You need to turn on OLE Automation Procedures on your server.

Please run following SQL command and you will see the result as 'Spain'

exec sp_configure 'Ole Automation Procedures',1

go

reconfigure

-Amey

Hey Matt,

Have you got any solution for this problem. I'm facing the same issue.

Thanks,