actually i figured out the error .The problem was that i had the data type as text and the textfile was written in a fixed field format.Hence the unusually large file was created.I changed the data type to varchar(5000) and it works fine now.
Thanks anyways.
Jay