Import excel file into SQL server database using SSIS package

See more:

SSIS

Hello Everyone,

I am working on Data Warehousing project where my work is to download the file from share point site and import it into Table in SQL(using Excel source and oledb destination). but Daily in file column data types are changing. Sometimes comes Varchar, next day same column can be nvarchar and some other day it can be ntext also and when i convert it manually using conversion it goes through.

I am using visual studio 2008 and Package is developed on Server where we dont have Excel installed.

Please help me with any alternate solution.

Thanks in advance.

What I have tried:

I tried Imex = 1 and HDR = Yes in Excel connection string. but dint work out. and even sometimes i get error External table is not in expected format.