Hello, I have a text file that is 27 megs. I import it into a single
SQL server varchar field and delete some rows that aren't properly
delimited. I then output the file to a new text file. The text file
comes out 405 megs! I have tried shrinking the size of the varchar
field and change nvarchar to varchar but the file came out exaclty the
same size. Why is less text that was contained in the original file
creating a larger text file than the original!?

Thanks!
Ryan

Okay, never mind...it was in the data transfer pump where the problem
lay... the column size was defined as 4000. I changed it and the file
shrunk down to a manageable size.