Visual Studio build fail on Dataset

I have had this problem for years.

I have a dataset. I open the dataset in visual studio. I want to change the connection string. I right click on the tableAdapter in the dataset view to open the properties tab. I change the connectionString to another connection string. Checked: The new connectionString is defined in web.config.

I build the project. The compile of the dataset fails with error: Failed to generate code. Exception of type ‘System.Data.Design.InternalException’ was thrown.

Even if I reverse my decision and set the tableAdapter back to the old connectionString, it still fails.

The only way I can get around this is to restore the dataSet files from backup. Or recreate the dataset which is cumbersome.