Difference in data size in SSIS output and SSMS output

Question

I have an SSIS package that retrieves data using an SQL command from a database and then generates a delimited text file 1452kb

I run the same request in SSMS and the generated text file, which 1499kb

Both data give the same number of lines, which may be the reason for the difference in file size and ways to solve this problem.

Answer 1

Assuming the files contain the same data. There are many things that different sizes can do:

• Encoding: If you use Unicode, it can store additional data, such as the Byte Order Icon (BOM)

• : , . CR - - ( ) LF . , . CRLF - .

• :

• : ,

,