The use of raw files as SSIS data source is highly recommended for huge volume of data due to its superior read/write performance. Raw files store data in a very basic format that requires almost zero translation and parsing. This enables faster data reads/writes when compared to Flat Files and even faster than Database tables. Continue Reading
raw file source
High Speed Data Transformation Using Raw Files
This post explains a SSIS technique that transforms large volume of data in shorter time by using Raw Files. Continue Reading …