SSIS Loose data from Excel.

• rfugikawa

  SSC Eights!

  Points: 848

  More actions

  January 15, 2009 at 11:18 am

  #126759

  Hi,

  I have an Excel to import into SQL Server 2005 by SSIS.

  The column "Complement" has text and/or numeric values(like apartment's number). Excel Connection Manager doesn't show the numeric values when I press the preview button or when I execute the process.

  help me please....

  Additional Information:

  - I can't save the Excel File in other format;

  - I can't open and change the columns because I receive the file from a cliente.

  Thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 15, 2009 at 11:38 am

  #927581

  You need to use the IMEX command in the connection string. MSDN has all the details.

  I had the same problem a while back and posted the detailed solution on this page. Search here and you should find it. (Search for IMEX.)

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• rfugikawa

  SSC Eights!

  Points: 848

  More actions

  January 15, 2009 at 12:08 pm

  #927608

  Perfect your answer...

  Thanks so much!!!

  😀