Exporting to txt file

[stonecoldjk]

I am running a DTS package exporting a table into a notepad.The table has 6800 odd rows of data. Once the package is run (which is does successfully), the size of the text file created is 14 GB ,which is ridiculously high.If i query the table and copy paste the results into a txt file it comes to around 4.5 MB .Why is this anomaly occuring ? Any clues? .Also i am not able to open the txt file once its made as it says throws up an error message.I cant even check what the file has or whether it was compiled properly.All help and suggestions are welcome.
Thanks in advance
Jay

[mushroom]

anomaly is the word for it. There are very few if any text editors that can open a file of that size, also the OS your are using may limit the file size that can be handled. Posting your Os may help.

[stonecoldjk]

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

[ronniethedodger]

Hey Jay -- don't you just love the "self-healing" quality of the forums here? ;0)