SSIS Raw File and Flat File

What is the difference between a Raw File and a Flat File in SSIS?
Please kindly provide a full answer here without links to articles.
Thanks.
ksfokAsked:
Who is Participating?
 
da-zeroConnect With a Mentor Commented:
A flat file is just any ordinary file with text in it: a .txt file, a .csv fiel and so on. If you open them, you can read them.

A raw file is essentially a dump of your data in SSIS to the file system. This is done in a proprietary binary format, so you can't read them yourself. This is used for quickly reading/writing data between different stages in the ETL.
0
 
ksfokAuthor Commented:
OK
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.