Import Excel 2010 file, and return an wrong row count

Question

Post reply

Import Excel 2010 file, and return an wrong row count

xuhui duan

Grasshopper

Points: 16
More actions
May 14, 2013 at 8:22 am

#277530

Hi,I am trying to load a excel 2010 file to sqlserver2005, I used visual studio 2005 and excel datasource, the original excel file shows 9924 rows,however, I used the rowcount transform, and the rowcount transform only show 9680 row. Could any body help please

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

You could try exporting from Excel to a CSV file and importing that. You'll have fewer problems, I assure you.

duanx SSC Rookie Points: 28 More actions · Answer 2

Thanks. I tried. There were a lots of datatype truncate error.

duanx SSC Rookie Points: 28 More actions · Answer 3

I figured it out. when do imported, I chose the source table or view the one without $. that cause the problem. However, I still did not get it, why there is only one sheet in the original excel file, and ssis shows three source table or view. for example, the sheet is named 'detail', the source table or view show 'detail','detail$' 'detail$_'.

Import Excel 2010 file, and return an wrong row count

Cookies on SQLServerCentral