Here are some things that I use RAW files for:-
1. Passing data between Dataflows (the original purpose of RAW files as I understand it).
2. As a medium for shipping data to another computer/database.
3. As way capturing data from site and taking it back to the office (i.e. backing up and restoring data from a table).
4. To hide columns between Transforms. This is sometimes that only way to get SSIS to "forget about" some of the columns that can accumlate in a Dataflow.
Having at times used Excel files to export/import data, I have found RAW files a much better alternative because Excel can cause so much grief when it takes a guess at data types.
The only thing that you miss is the ability to view the data in Excel. There is at least one RAW file Viewer around though.
One thing I do is use a variable for the RAW file name so that it can be unique for each execution, which means that you have to make sure to delete it when you are finished. I think that it would be useful is there was an option for SSIS to delete the RAW
file automatically at the end of package execution, making it a little bit like a temp table in TSQL.
View Complete Post