Post reply

Error handling issue in Flat file source

  • November 29, 2011 at 7:57 am

    #248739

    Hi All,

    I have an SSIS-2008 package which extracts data from a fixed width flat file.

    For handling bad records (which fail to have defined length), I have used "Error Output" properties.

    Issue here is, when system encounters a row that has less record length than defined it will reject this record along with next "valid record".

    Thus I lose a immediate next valid record from being extracted, though it has right data with defined length.

    This is because data from next record will be pulled into bad record since bad record length is less than defined.

    Any way to handle this? I would like to reject only reocrd having less record length.

    Thanks in advance. 🙂

  • November 29, 2011 at 8:20 am

    #1414120

    The simplest solution, as far as I know, is to just not use the fixed width delimiter when doing your import.

    I assume you have linebreaks as your row delimiter right? In which case, just have the whole row get imported as one record. Then, use a derived column transformation to create your different output columns.

  • December 1, 2011 at 2:21 am

    #1415082

    Yes, this is a very good alternate. Thanks 🙂

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

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