SNP leader John Swinney hopes that some of Sean Connery's charisma will rub off.