Post reply

Error:Number of failed rows exceeds maximun specified

  • September 9, 2004 at 7:43 am

    #60214

    Hi to everyone

    I run DTS package that imports data from MS Navision database to SQL Server 2000. One of the source fields is Date (of datatype date). When I copy it to the destination table's field Data (of datatype varchar as well), the DTS throw the following message:

    The number of failed rows exceeds the maximun specified

    I have tried dropping and re-creating the destination table prior to the data import. Still the same message appears. Any comments and suggestions would be of great help to me.

    Cheers.

    Katia

  • September 10, 2004 at 3:19 am

    #522487

    Hi,

    I think you should first avoid the error ... like converting the DateTime into varchar (if it's the cause of your error).

    Anyway, a "Transformation data task" in a DTS pakage has an option "Max error count" wich is set to 0 by default, meaning stop at first error.

    You can increase this value, but you still have a limit (like 999...9, don't know exactly). If for some reason you can't avoid the error and could reach this limit, you should use a VBScript, to test, trap the error and skip the faulty record. But be aware that scripting in DTS leads to poor perfomance ...

    Hoping it can help.

    Regards.

  • September 10, 2004 at 6:08 am

    #522518

    Dear sontracteur

    I have tried converting the destination Date field to varchar and char datatype at first place, but stil the same message appeared. I thought there must be some another reason for getting this message.

    What I actually did and it worked was importing data from Navision table to to Access database at first, and then importing it back to SQL Enterprise Manager database. It is not an ideal solution though....

    Thanks for you help 

    Cheers,

    Katia 

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply