THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Microsoft Data Platform MVP from the Netherlands

SSIS - Let the Excel connection manager pick the right column data types from an Excel source

You can read this blog post at this link:

This blog has moved to There will be no further posts on Please update your feeds accordingly.

You can follow me on twitter:

Published Wednesday, November 18, 2009 12:01 AM by jorg

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



jcridge said:

Does anyone know, in a loop to read many Excel files, does the excel connection manager RESCAN the first N rows for each file it opens

OR does it set the data types based only on the first file it finds ?

October 15, 2012 8:35 AM

Sven Aelterman said:

Thanks for sharing this.

Setting the value to 0 actually still only scans the first 16384 rows, which in some scenarios can still be a limitation (as discovered by

We should encourage Microsoft (through Connect) to just accept the fact that the developer knows best and if we specify a certain data type for a column to accept that's what it is.

February 1, 2014 7:22 PM

Sven Aelterman said:

@jcridge: it will rescan for every file it opens.

February 1, 2014 7:23 PM

Leave a Comment


About jorg

Jorg Klein, Microsoft Data Platform MVP from the Netherlands.
Privacy Statement