THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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: https://jorgklein.com/2009/11/08/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source

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

You can follow me on twitter: http://twitter.com/jorg__klein

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

Comments

 

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 http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6496b806-c0d9-4ab7-b309-aa34550aaa1d/ole-db-connection-error-failed-to-retrieve-long-data-for-column?forum=sqlintegrationservices&prof=required).

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

(required) 
(required) 
Submit

About jorg

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