Given I have a Dataflow with one or more queries to data source A When I change the queries to use data source B And I remove data source A from the gateway And I go to the Gateway connection for ...
I have unfortunately had to adapt our deployment processes to account for this. When we change a data source for a data flow, we export the data flow, delete the existing one, re-import that same data flow (just to get rid of that obsolete data source). Then, we have to set up the new data flow (credentials, etc.), andadjust anything that has a reference to that data flow to use its new GUID.
So, Anonymous, you have my sympathies, at least.