When I start creating a new DTS Package and I choose the Analysis Processing
Task icon, I only have the option of working with the local Microsoft
Analysis Server.

How can I choose a remote server's Analysis Server in order to process its
database?

Thank you

In the lower left hand corner of the AS Processing Task box you should see a
checkbox which says "local server", uncheck that.

If you're still not seeing the proper server, it may be a security issue. I
don't dev DTS packages on my local box but rather I have to TS into a box
which is open to AS.



"serge" <sergea (AT) nospam (DOT) ehmail.com> wrote