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: 247180

  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.

  ---