SSIS Flat File Source - Redirect Row

• ShuaibV

  SSCrazy

  Points: 2001

  More actions

  December 19, 2017 at 4:06 pm

  #341401

  Hi 
  I have the Flat File source connection in Data Flow Task and configured redirect row when the truncation occurs.  Can you please help how to know which column has the truncation error and how to get the row number?  We dont have the row number in the file.

  Thanks

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  December 19, 2017 at 4:59 pm

  #1972826

  Can't you compare the file to the exception file to find the rows. In my experience truncation errors may be thrown when the flat file connection manager has the column defined too short. Define each column length in the connection manager too match the destination. Another approach is the create a staging table with an identity column and single wide column for the file rows, load all the columns with delimiters into the one column and load from there where you will get a truncation error if data is longer than the destination table.