Excel Source: Dynamic Named Ranges Not Visible

• matt.tucker 55791

  SSC Enthusiast

  Points: 158

  More actions

  October 25, 2011 at 9:09 am

  #246938

  I'm trying to import an Excel workbook that has several datasets, but when selected the Excel sheet in the Excel Data Flow Source, none of the named ranges that use the offset() function in excel appear in the Source Editor.

  Named ranges that do not use the offset() function appear fine, but unfortunately, all but one of the ranges use offset() to avoid importing empty rows.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  October 27, 2011 at 3:57 am

  #1400042

  Another approach to avoid empty rows is to write a SQL statement to your Excel worksheet and use a WHERE clause with IS NOT NULL on a certain column.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• matt.tucker 55791

  SSC Enthusiast

  Points: 158

  More actions

  November 1, 2011 at 7:35 am

  #1401603

  Thanks!