I work with quite a bit of different Excel sheets and often receive
columns with mixed data. Sometimes the alpha data won't appear until
much further down in the sheet, leaving me with NULLs imported instead
of the alphanumeric data. I realize that I can add IMEX=1 to the
connect string to enable importing mixed columns, but was wondering if
there was a way to default this setting within SSIS and possibly even
the Data Import wizard?

Thanks.

-Pete Schott

Hello Paschott,

Unfortunately I do not think you can default this setting. You could of
course extend the Excel Source Adapter by writing your own adapter and having
this set by default in there.

Allan