Using BIDS to load Flat Files, How to Skip Empty Rows?

• bkmooney

  SSCrazy

  Points: 2041

  More actions

  March 7, 2014 at 1:58 pm

  #290736

  I'm building a package to load flat files and have found that some of my files have empty rows at the bottom. I'd rather prevent them from being loaded than have to go back and delete them from an indexed table later.

  Is there an easy transform I can do right before the load to OLE DB Destination step? Feel like I'm missing something obvious...

  Thanks!

• SQLCJ

  SSCommitted

  Points: 1791

  More actions

  March 10, 2014 at 1:38 am

  #1695427

  why not use conditional split transform to eliminate empty rows ?