Post reply

removing a comma

  • August 5, 2014 at 4:46 am

    #1735090

    ronan.healy (8/5/2014)

    its not a single column there is 20 columns in the file. I can see why its causing the error. on the column delimiter its set to comma(,)

    if I try anything else it doesn't bring back any data. is there any way around this

    It seems your csv file is not a great csv file.

    If the 20 columns are seperated by commas, there should be no commas in the data itself, unless they use a text delimiter at the start and end of each text column.

    Just changing the delimiter in SSIS won't help. You need to change the actual format of the file.

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

  • August 5, 2014 at 4:56 am

    #1735091

    thanks for the help. changing the file to text delimited its working fine now

Viewing 2 posts - 16 through 16 (of 16 total)

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