Thanks for the reply. However this is how I got it done..

Instead of using SQLServer 2005's Management Studio I started the data import from Enterprise manager of SQLServer 2000 and...