Question: what is imex=1 in ssis?
Answer: Suppose you have excel and in that excel we have a column that contains mixed data type (like number, date, string etc.). "IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc.) ... data columns as text.