When does Sims 2 on DS finish?

To be honest, it doesnt. You finish the story after you defeat the robot as the raticator, this is after you get over the blueprints phase and potion thing. Then it will give you a movie scene before credits. Once that's over, the hotel is yours to run and maintain. You still get missions to complete and guests to look after just as before.