I despise Sweet Caroline but I'm fairly certain it will be used at the end of the show.
I'm not sure why it would have to be at the end of the show specifically - it could be anywhere. (Or it could appear *again* at the end.) But, wherever it is, I do hope that they realize that Boston audiences are used to participating in the song (for better or worse lol). :-)