Yes, that can be done and is quite helpful for doing data type changes en masse. However, because the Name characteristic is unique it must be done on a per-column basis.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices