It's going to be no party = It isn't going to be a party = It isn't going to be pleasant. "Living with you is no party." = "It's very unpleasant living with you." We also say "This is no picnic" = It's unpleasant or difficult.