problem with FirstRowHasColumnName in excel source connection manager ssis

• arulmanicse

  SSC Veteran

  Points: 207

  More actions

  December 16, 2008 at 1:29 am

  #132990

  hi,

  im using foreach loop to transform data from many excel sheets in a file to DB. i set the FirstRowHasColumnName false in connection manager. but while running it changes to true. and i cannot change it into false. how can i change it to false.

  help me please...

  thanks in advance

• mamsay

  Say Hey Kid

  Points: 701

  More actions

  December 16, 2008 at 4:38 am

  #913042

  hi,

  for this the solution is...

  go to connection manager-->properties-->expression-->connectionstring-->and then change the value of HDR to NO