SQL Server Performance

Import AlphaNumeric Column From Excel File using SSIS

Discussion in 'SQL Server 2005 Integration Services' started by patel_mayur, Mar 14, 2008.

  1. patel_mayur New Member

    I am trying to import data from excel file into SQL Server using SSIS. One of the column in excel file having most of the numeric values and some character values.
    I have already modified connection string by appending "IMEX=1" for Excel Connection, but still not getting correct data imported to SQL.
    Can anybody throw some light why "IMEX=1" not working for me ? I dont want to update registry value and also dont want to modify excel file as it would be daily feed from excel to sql.
  2. satya Moderator

Share This Page