Was vinland colony a great success

It wasn't. The Vinland colony was not sustainable since it wasn't possible for Norse people to move there in high numbers and carry things and establish a successful colony. Their ships were smaller than those used by later people like Columbus and there wasn't an option to just take three ships with a bunch of people. Technology wasn't yet developed enough to enable a mass migration.