Executive sponsors play a key role in the success (or failure) of digital transformations. Taking these essential actions will tip the scales in your favor.