how do delete blank line in flat file while loading to table -SSIS

• Saintmount.Sql

  Ten Centuries

  Points: 1023

  More actions

  June 6, 2011 at 10:15 am

  #251291

  I will be receiving flat file & Its has two blank lines at the end. One blank line needs to be deleted or it will create blank record when loaded.

  How to handle or to write a code to ignore extra blank line at the end.

  Thanks in Advance

  Thanks,

  Vijay

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  June 6, 2011 at 10:20 am

  #1334504

  Use a conditional split to redirect the unwanted lines to an unused output as part of your data flow.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel