Is there an easy method/sample code for making wholesale changes to the data
type and data size properties of dimensions to match the a current SQL data
base definition?

The situation I am looking at is that the SQL data base which is the source
of data for the OLAP cubes/dimensions will reference views. The same set of
views will have different data type characteristics in each implementation.
So, I am looking for a quick method for synchronizing the data type and data
size properties to match the column defintions of the database.

Are there any quick tips for doing this? Sample code?