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

    Hi,
    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.
    Thanks
  2. satya Moderator

Share This Page