aharmon-1091890 (4/6/2010)
are you getting any errors or warnings when you execute the package? My initial guess is that SSIS is trying to guess the datatypes, and when it sees the first row is blank, it may choose the wrong type. Are you getting nulls in the final table?
I have to go with Aharmon here. Try putting IMEX=1 in your connection string.
For more information, see this URL:
http://swap.wordpress.com/2007/09/18/solution-for-excel-data-uploading-problem-using-ssis/
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP