How to find Missed Records in SSIS Package

• Senthilkumar-456461

  SSC-Addicted

  Points: 491

  More actions

  August 24, 2007 at 1:58 am

  #180478

  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

   

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  August 24, 2007 at 4:47 am

  #729214

  Hi,

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

  Hope this help.

  Raj.

• Senthilkumar-456461

  SSC-Addicted

  Points: 491

  More actions

  August 24, 2007 at 5:18 am

  #729222

  Hi,

   My doupt is How to get missed Records.

  Thanks

  Thiru

• Tim Mitchell

  SSCoach

  Points: 15681

  More actions

  August 26, 2007 at 8:44 pm

  #729468

  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