[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3630
  • Last Modified:

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.
0
ksfok
Asked:
ksfok
1 Solution
 
da-zeroCommented:
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now