title: SSIS is forcing Excel data types I don't want. Changing connection string isn't working
body: <p>I am importing from an excel spreadsheet and it is not allowing me to change the source column type from Double to Unicode string.</p>
  
  <p>I have tried using "IMEX=1;" in the connection string but this appears to be doing absolutely nothing.</p>
  
  <p>The package refuses to validate and when i execute the package therefore will not run, and it keeps wanting to rest the "Input" of the external column to "Float" when i definately want it "Unicode", even though I've set "Validate" to false.</p>
  
  <p>I must be missing something?!!?</p>