I am recently learning SQL Sever & is facing a problem with it... I have received a message saying "The number of failing rows exceeds the maximum specified". How do i increase the failing of the maximum specified for row???
I am recently learning SQL Sever & is facing a problem with it... I have received a message saying "The number of failing rows exceeds the maximum specified". How do i increase the failing of the maximum specified for row???
CASE :
A cause of this error can be that a leap year is set up for the wrong year. Check all the February period end dates and ensure that all leap years are set up for the correct years.
Solution :
If you find a leap year set up for the wrong year you must correct this in the General Ledger as this will cause a Null value in our tables. Once this is done re-run the load.
There is a simple solution for it. You need to select properties of Transform Data Task by right clicking on it, then select the Options tab. Now change the Max Error Count in the dialog box.
Bookmarks