How to handle data load failure in SSIS?

 There are different ways to handle data load failure. 

1. On dataflow you can redirect failure rows to another location and later retrieve it. 

2. You can also set ignore failure rows on destination settings. 

3. Easiest way is configure destination columns to easily convertible datatype like Varchar/strong with proper length. 

4. If failure can happen due to network issue or connection issues then you can set up retry mechanism. 

5. If it's happening due to memory then you can review the batch size and go for sequential load instead of parallel loads. 

No comments:

Post a Comment

Write a python program to find factorial of a number ?

Factorial  When we recursively multiply number incrementing from 1 to a given number then its called factorial of that number. We use the no...