Post reply

.csv file importing with comma separated delimetres

  • September 25, 2011 at 10:55 pm

    #243633

    Dear All,

    I am importing the data from .csv file which is having below data format.

    1992,January,NS,General - Ordinary,Normal Arrangements PSS,"204,015","$4,002,797 "

    1992,January,NS,General - Safety Net,Normal Arrangements PSS,"324,060","$5,316,134 "

    The row with value "204,015", has getting split as given column delimiter as comma(,).

    How we can isolate this problem with flat file connection with SSIS 2005.

    Thanks,

    Ganga

  • September 25, 2011 at 11:05 pm

    #1386282

    Ganga,

    This is an invalid CSV format specification.

    Please follow the link here

    Raunak J

  • September 25, 2011 at 11:20 pm

    #1386285

    Hi

    Thanks for the link.

    As the CSV file has been generated from database the vale "204,015" is stored in this manner only.

    Though i am using " " for a single filed its getting split.Some body could you please help me.

    Thanks,.

    Ganga

  • September 26, 2011 at 12:54 am

    #1386292

    Gangadhara MS (9/25/2011)

    Hi

    Thanks for the link.

    As the CSV file has been generated from database the vale "204,015" is stored in this manner only.

    Though i am using " " for a single filed its getting split.Some body could you please help me.

    Thanks,.

    Ganga

    In the flat file configuration manager, you need to specify " as the text qualifier.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 26, 2011 at 12:56 am

    #1386293

    Shouldn't that be the case where every field in the file is qualified by a quote? Just curious.

    Raunak J

  • September 26, 2011 at 1:02 am

    #1386297

    Raunak Jhawar (9/26/2011)

    Shouldn't that be the case where every field in the file is qualified by a quote? Just curious.

    No. So you were a bit too fast by telling the OP that his CSV was invalid.

    If you'd read the entire Wiki page you referenced to, you would have noticed that 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 26, 2011 at 1:04 am

    #1386298

    Thanks for pointing that out. Let me have another read. 🙂

    Raunak J

Viewing 7 posts - 1 through 6 (of 6 total)

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