Going to a good school is by no means a ticket to success. However, many of the people who get into such schools are hardworking and driven, which I’m sure would then apply to their careers after college. The school you attend may be advantageous in giving you its ‘name’ which I guess could put you ahead in a few job applications etc, but after a few years your work experience and personality will count more than where you went to school. Also, the people, connections and opportunities available at a school could impact future success, but the vast majority of the time none of this will be any good if you don’t put the work in.
Many people who went to lower level colleges (or even didn’t attend college) have been succesful, it’s not the be all and end all.
(This is just my opinion)