Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Unanswered: DTS error too many columns found

    Trying to import a text file with a 11 columns, column delimiter is ;
    record delimiter is CR+ LF.
    Using a DTS package (bulk copy)
    Then I got erros with these discription
    -----------------
    SYMPTOMS
    When you import a text file into Microsoft SQL Server by using the Transform Data task, if no text qualifier is specified and a row with too many columns is encountered, the load of the text file may fail with the following error message:

    Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
    Error Description:Too many columns found in the current row; non-whitespace characters were found after the last defined column's data.
    Error Help FileTSFFile.hlp
    Error Help Context ID:0
    The preceding error message repeats in the DTS exception log N times, where N is the value of the Max Error Count setting on the Transform Data tasks options property page.

    CAUSE
    This problem occurs because of a malformed source text file in which the DTS Data Pump encounters a row in the source file that contains too many columns.

    http://support.microsoft.com/default...en-us%3b300181

    -----------------------
    I tryed the fix of Microsoft but no result yet.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Did you get the specified hotfix from MS Support?
    For information refer to thisSQL MAG thread.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Posts
    2
    Originally posted by Satya
    Did you get the specified hotfix from MS Support?
    For information refer to thisSQL MAG thread.
    Yes I got the fix en installed but I have still the errors.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Then better to report back to MS Support.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •