SSIS 2008 - Load a last row in a file

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  November 16, 2010 at 12:24 am

  #228804

  A file is being loaded into a sql table. the last line of the file wud be different compared to other rows. So how should i load that last row into the same tbale or if its possible, into a new table that line only.

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  November 16, 2010 at 5:57 am

  #1251258

  Conditional split?

  If you can detect it by the data in the row.

  if not (and I haven't tried this)

  Add an aggregate to hold up the data flow until the rowcount can be calculated then use that to split off the last row.

  
  Cursors never.
  DTS - only when needed and never to control.