Home/Questions/Q 29810
Next
In Process
ekichikova
  • 0
Asked: 2023-04-19T20:37:16+00:00 In:

Loading table with millions of rows and there is one row with bad data. Loading fails, how do you find out which row has bad data?

  • 0
Loading table with millions of rows and there is one row with bad data. Loading fails, how do you find out which row has bad data?
pure insurance
Share

    Leave an answer

    You must login to add an answer.

    Need An Account,

    1 Answer

    1. In ssis we can handle this type of errors in data flow task, there is configured error output. By redirecting rows in sql table or other text file with bad data we can identify those errors

      • 0