bsitto: He's not the one for you.
When you meet your soulmate you will know it into your bones, and more than that, the universe will shift mountains to have you be together. This isn't happening with the man you love at all, he's married with a child and he has too much honour to give up such a strong commitment. Feel grateful for the time you did get to spend with him, and the friendship you two now share.
I see him as being a guiding light in your life. He was sent to show you that such a deep and loving connection between you and someone else is indeed possible and that you shouldn't settle for anything less than true happiness. Right now he feels like he is the one you are meant to be with, but, without a doubt, there is someone even better for you that compliments you in EVERY way. It seems impossible now, but it will happen, you just have to be open for it.
Look around you for the very tiny hints the universe sends you in regards to finding who you are meant to be with. They are there, but right now they are just whispers. Follow them.
In the end, if you were meant to be with him, you would be now. You knew him for two years and as much as your relationship grew, it didn't turn into marrage. Life got in the way, you both had stuff to deal with and I think this is why you met, to help each other grow and to show you what could be.
For now, chrish the time you had together, and look towards a brighter future. Your real guy is out there somewhere.