Post reply

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

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply