Click here to Skip to main content
11,920,413 members (40,018 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


2 bookmarked

Determine the datatype for excel import

, 25 Feb 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
Determine the datatype of a column in a Excel file in SSIS


Determine the datatype of a column in a Excel file in SSIS


Whenever we are working with SISS for the task of importing rows from a Excel and saving it to table with our without any manipulation in database, SSIS does type guess and determines what will be the datatype for the column. 

In general based on few early rows of a column SSIS fix the data-type and same datatype is consider for all the remaining  rows, by default it is set to 8 rows by Windows. When the case arise where we have initial few rows as empty or null followed by numeric values, SSIS consider it as string datatype and create issue when it is mapped to any Integer type of column of a table in SSIS.


To overcome it we can increase the typeguess row size in the windows registry and so that data-type will be considered after tracing the rows of specified number of rows.

 It is available in following path:


 regedit --> HKEY_LOCAL_MACHINE --> SOFTWARE --> Microsoft -->  Jet -> 4.0 --> Excel


Double click on the TypeGuessRows property , select the Decimal in Base and type the number of rows that need to be traced before determing the datatype. 





This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.151120.1 | Last Updated 25 Feb 2014
Article Copyright 2014 by govardhan4u
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid