Post reply

How to insert values having comma

  • December 8, 2009 at 9:19 am

    #143437

    The problem is like this

    I have one comma separator file, and there is one column which is having value of comma.

    Column1 Column2 Column3 Column4

    "Srinivas P" "AMGR" "K,Suresh" "MGR"

    If I import this data using SSIS(bulk insert) then I am getting values shifted to next column (i.e. <,Suresh"> is getting shifted to next column and <"K> is in column3).

    Thanks in advance...

  • December 8, 2009 at 9:27 am

    #1089330

    It looks like they are using (") to qualify the text.

    On your Flat File connection manager editor - enter " in the text qualifier box

  • December 9, 2009 at 6:19 am

    #1089772

    Thanks its working...

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

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