Post reply

~ delimiter problem

  • August 13, 2010 at 1:28 pm

    #141656

    Hello..

    I am trying to bulk insert a .txt file into sql server but the file has ~(tilde) column delimiter. But it looks like there is no option for that in bulkinert..option...column delimiter....So, IS there a way to fix this problem....

    I found that format file option is a way to do...But how do I cretae the format file ? HELP PLEASE

  • August 13, 2010 at 2:01 pm

    #1206922

    SSIS.COM (8/13/2010)

    Hello..

    I am trying to bulk insert a .txt file into sql server but the file has ~(tilde) column delimiter. But it looks like there is no option for that in bulkinert..option...column delimiter....So, IS there a way to fix this problem....

    I found that format file option is a way to do...But how do I cretae the format file ? HELP PLEASE

    Why can't you use the data flow task for this? In your flat file connection you can just add "~" in the drop down even though it is a drop-down. It has worked for me in data flow task.

    You can try the same with bulk insert also by typing "~" character under ColumnDelimiter property.

    [font="Arial"]BASKAR BV
    http://geekswithblogs.net/baskibv/Default.aspx
    In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

  • August 16, 2010 at 3:57 pm

    #1207600

    Thanks Baskar. It worked.

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

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