How to find Missed Records in SSIS Package

  • Hi SSISins,

        I created one package which is importing data from Excel sheet. My Excel sheet having 100 Records. one record is missing While importing these records to sql server table.

        Could any one tell me HOW TO FIND MISSED RECORDS?.

     

    Thanks

    ThiruSenthilkumar

    EAG-Deloitte

     

  • Hi,

    this Problem occurs when the column length is less then the passing value length.

    Hope this help.

    Raj.

  • Hi,

     My doupt is How to get missed Records.

    Thanks

    Thiru

  • You can redirect rows in error to an alternate location, for example an output file for review.

    hth

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

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

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