P Jones (3/5/2015)
That said we do often import spreadsheets in SSIS, but you have to remember that the excel connector decides the field types based on the first ten rows of the spreadsheet and that can be completely the wrong thing.
There is a registry setting that you can change to make it scan more rows.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP