An error occurred while importing data from excel in SSIs. letters and numbers are added and the result is changed to null.

When I checked DW data today, I encountered this problem:

 

 

There is a column value in Excel:

H2000

18283

T3438

....

Actually, all the letters in the database are changed to null...

 

Is imported through the Excel source of SSIs.

 

 

In Excel source, the preview is found to be null.

 

Check whether the problem is Excel.

 

Next, find the solution.

 

Finally, we found:

 

In the connection string, tell Excel how to interact with the mixed-data-type column data.

 

Tell it take it as a text...

 

Solution:

 

Add the following to the connection string:

Extended properties = "Excel 8.0; HDR = yes; IMEX = 1 ";

 

 

"IMEX = 1" is what you want to add.

 

Do not fill in the wrong position.

 

Thank you.