Post reply

Batch processing Error handling

  • June 24, 2009 at 7:43 am

    #95605

    Hello everyone,

    Recently I have to bulk insert around 250000 rows and found that my bulk insert is failing on one particular record and that process is failing. Is there anyway to find for which record the bulk insert is failing.

    Ta

  • June 24, 2009 at 7:52 am

    #1014654

    Try setting the MAXERRORS parameter to the BULK INSERT statement - the default is 10 which means that the process only stops and reports after the tenth error.

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • June 24, 2009 at 8:29 am

    #1014683

    Hi Paul,

    I have specified that option already. I think problem lies either at the record or process level.

    Error

    Bulk Insert fails. Column is too long in the data file for row 3, column 4. Make sure the field terminator and row terminator are specified correctly.

    It exactly fails after the particular record count. This means either the record or memory level fault. I need to identify them at lower level.

    Any suggestion?

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

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