is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

• stan

  Ten Centuries

  Points: 1307

  More actions

  December 10, 2025 at 6:56 pm

  Go to Answer

  #4698524

  is there a no code way to limit an ssis extract from excel to the 1st 21 rows of the sheet?   for now anything past that is just noise in what im doing.

• Phil Parkin

  SSC Guru

  Points: 247202

  More actions

  December 10, 2025 at 7:13 pm

  Answer

  #4698533

  Sure there is. In your Excel source, define a suitable sheet name and range, eg

  Sheet1$A1:H21

  ---