sqlJunkies2 (6/9/2009)
they will inadvertently reset all the production value to development value settings from the package
This is a good argument for using a lot of small configuration sets, to limit the damage.
You could also use a trigger to reject UPDATEs that didn't come from a "SQL Server Management Studio" connection. Then new configuration sets could be created in BIDS, but updates would have to be done using the stored procs.