Post reply

Importing .CSV into 2005 vs 2000

  • March 10, 2009 at 5:41 am

    #131597

    I have a text file with addresses. One column has data with a comma: "WASHINGTON, DC"

    and has the double quotes. In SQL 2000, the import wizard had a default to ignore the commas if they were inside double quotes and the user had a simple time importing the data. Now with SQL 2005 I can't find the equivalent. The import wizard breaks apart the string into 2 separate fields, so I have "WASHINGTON and DC"

    Also, in 2000, it would automatically map the columns to the fields in the table. Looks like in 2005 I need to specify each mapping.

    Am I missing something obvious ? (Wouldn't be the first time)

  • March 10, 2009 at 6:07 am

    #956698

    There is a Text qualifier box on the General tab of the FlatFileSource Import wizard. Defaults to none but you can just type the double quote in there.

    Also choosing a delimited format should allow the wizard to 'have a go' at defining the columns.

  • March 10, 2009 at 9:00 am

    #956864

    I think that did it, thanks. I had put a double quote in their twice, but should have put just one.

  • April 22, 2009 at 4:47 pm

    #982601

    You need to assign the Text qualifier as " (double quote) while creating the flat file source connection for CSV file.

    Thanks.

    Gunjan.

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

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