Post reply

Embedded Text Qualifier Error

  • June 20, 2016 at 12:29 pm

    #400305

    When importing a flat file I receive the following error - [Flat File Source [2]] Error: The column delimiter for column "Column1" was not found.

    Example Record: ""First Name" "LastName""

    The error is being caused by an embedded text qualifier, but from what I see online this bug was resolved in earlier versions of SQL Server. In fact this file imports successfully on our SQL 2008 server.

    Any suggestions for resolving this issue?

    Thanks!

  • June 20, 2016 at 12:38 pm

    #1885905

    What are you using for the import? How did you set it up? Is the file delimited, and by what?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 20, 2016 at 12:42 pm

    #1885907

    I receive the same error whether I use the import wizard or use SSIS. File is comma delimited and text qualified with quotes. File imports successfully if the embedded quotes are removed from the column.

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

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