I have a BI solution that I've inherited. I'm trying to re-point my .ds to a
different server. This works OK. I then want to make sure that the
connection manager in my .dtsx is pointing to the updated .ds. That seems to
be the case. However, when I right-click on the connection manager and show
properties, the connection string is still pointing to the old server. I
don't get it. When I simply double-click the connection manager, it brings
up the .ds pointing to the correct server. I even tried building the
connection string in the properties, but it won't save. The problem here is
that the old server has gone away: I must point to the new server.

What step did I forget? Or is this a bug? I've had several set of eyes
looking at this, all to walk away shrugging their shoulders saying "I don't
get it". Me too!

Any help is greatly appreciated!