Fastest legacy File - Excel , CSV, Notepad
-
Thursday, January 31, 2013 5:34 AM
EXCEL / CSV / Notepad... Which is the fastest legacy file which can be loaded using ssis and why ?
ShanmugaRaj
All Replies
-
Thursday, January 31, 2013 7:17 AM
Surely not Excel, because SSIS will parse the file and try to determine datatypes.
There's no actual difference between CSV and Notepad, because both are flat files (entirely text).
I think fixed width or ragged right is a bit faster than a delimited flat file, since SSIS doesn't have to look for delimiters. Which means .txt (with no delimiter) can be a bit faster than CSV.If you have only date, time or integer values in your flat file, you can turn on FastParse to get even faster speeds.
Long story short, flat files are the fastest.
MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
- Proposed As Answer by SSISJoostMicrosoft Community Contributor, Moderator Thursday, January 31, 2013 9:19 PM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Friday, February 08, 2013 6:40 AM
.png)
