Post reply

SSIS : "31,123,322.23" inside excel csv file

  • October 5, 2017 at 4:45 am

    #323919

    Hello I am using a flat file source to bring data into my SSIS package.

    This is a csv file, but in some cases there are fields (normaly holding values that come in this format "31,123,322.23"

    What can I do in order for flat file source to understand that it should not look into commas as columns if they are inside the """

    I read that I may be able to introduce something like a escape character in the flat source but I don't know where. Can you please help?

    Thank you

  • October 5, 2017 at 4:48 am

    #1962438

    You need to set your Text Qualifier in your Flat File Connection as a double quote (").

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 5, 2017 at 6:00 am

    #1962444

    Thank you for the support. It works

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

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