Question: what is imex in ssis?
Answer: IMEX= 1 extended properties in ssis. 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.