question

pankajkumarshende avatar image
pankajkumarshende asked

SSIS - Excel file data load NULL issue

Hi, I am facing problem while loading excel in database using SSIS, for one of the alphanumeric column NULL values are loaded.

I read earlier blogs on this issue as SSIS scan only first 8 rows and apply datatype based on it.

AS a workaround : I have addded IMEX=1 in excel connection string/

and updated TypeguessRows property value to 0 in registry still no luck.

Error seems there, can anyone help me on this.

Thanks,

Pankaj

ssis excel
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
spaulich avatar image
spaulich answered

Pankaj,

Have you resolved this problem? I'm experiencing the same. Do you have workaround? Would you share?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pankajkumarshende avatar image
pankajkumarshende answered

Hi,

Excel data source didn't worked for me so i had used script task and added code in it to read excel data and load into table it works fine for me

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

spaulich avatar image
spaulich answered

Thank you.

I just discovered that when the column (or cell) is formatted in EXCEL to "GENERAL", text will not import, only Numeric pulls thru.

Be safe.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.