CODEWITHSUNDEEP
excelsql-server-2008ssisimport-from-excel
nojetlag
nojetlag

Reputation: 753

SSIS not importing TEXT column from Excel correctly (integer results in NULL value)

I have Excel 2003 files which are imported through SSIS into SQL 2008 R2. With one of the columns I hit a big problem. The column is defined as TEXT in the Excel sheet. Out of 36 rows 32 are having values like XTZ23, they get import correctly. The last 4 rows however are just numbers like 2646672. They are imported as NULL. If I change the connection String to IMEX=1 and modify the registry to TypeGuessRow=0 these numbers end up like 2.64667e+006.

What did I miss here?

Upvotes: 0

Views: 2592

Answers (2)

Tom
Tom

Reputation: 21

I know this is an old post, but for future searchers, just add IMEX=1 into the connectionstring of your Excel manager in the SSIS.

Upvotes: 2

Ivan Milosavljevic
Ivan Milosavljevic

Reputation: 839

First solution would be to change excel column format if possible. Second, I have had this problem 2 years ago, excel file couldn't be changed since I was getting it from another service ... I can`t remmember correctly but I have called custom code/function or it was some sort of transformation inside SSIS that was converting specific column rows from one data type to another.

Upvotes: 0

Related Questions