Avoin NULL values while loading Excel file

• krishraj19

  SSC Veteran

  Points: 240

  More actions

  March 2, 2009 at 8:01 pm

  #131480

  Hi all, i am loading excel file into my SQL Server destination. While loading i want to avoid NULL values. Is there any specific functionality for this? My excel file data looks like

  Cust_US 1098

  1000123 Mitchell internet sales FL US

  1000124 Craig ShowroomCust TX US

  1000125 Brenda On-line buyer WI US

  First row is header row and from second row the actual data. When i am loading the falt file i used two different sources to acheive this. One file loads only header and another file loads actual data.

  But problem with excel file is, i did not find any option called, avoid first row.

  Can someone tell me the best way to do this.

  Thanks for your help

  Thanks

  Krish

• bambang

  SSChasing Mays

  Points: 642

  More actions

  March 3, 2009 at 1:45 am

  #952258

  There should be no problem with excel header.

  In my experience, I'm just choosing External Column Menu (Column in excel) and the column header never loaded into table in my database.

  Maybe you should give the apropriate column name for your excel file, so that every column has a name.

  If your excel file consists of 4 column, give each column a name, so that SSIS may recognize it

  as a header.

  regards

• bambang

  SSChasing Mays

  Points: 642

  More actions

  March 3, 2009 at 3:05 am

  #952281

  Sry, please check Excel Connection Manager.

  There is an option "First row has column names". By default, this option already checked. 😀

  regards