It says it in the spell storing page. Once the weapon deals damage the spell is cast on the target immediatly. If there was a seperate roll involved it would be explicit on that. The weapon attack roll is the trigger, so adding another roll on top of that would be superficial.