Post reply

Exporting to SQL Table untill error occure in the data

  • December 10, 2009 at 6:45 am

    #218631

    Hi,

    I have a DTS application which exports text data to Table, but the job is getting failed by throwing given below error.

    “General Error -2147209197(80043013)

    Too many columns found in the current row; non-white characters were found after the last defined column’s data.”

    Is it possible to get the data up to the error line in the table? Now after the error there is no row in the table. This will help to identify the error easily, since in my case the input file size is in GB size and not easy to open and identify the error.

    Thanks

    Saeed

  • December 10, 2009 at 6:49 am

    #1090497

    You can change the batch size in the DTS package to a smaller number. I've done this in groups of 1000 to narrow things down, then you can change it further, modifying the start row and narrow down to small section of the file.

    This in the transformation by right clicking it and choosing the options.

  • December 10, 2009 at 7:30 am

    #1090542

    Thank you Steve for giving idea to analyze the error. hope you are mentioning about changing first row, last row and insert commit size. Let me try the same.

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

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