Post reply

Type conversion issue

  • January 30, 2012 at 6:44 am

    #267347

    with BCP command i am getting .csv output this will be uploading to sql table.

    I am exporting the data with pipe delimiter having 5 columns.

    While importing same data,One of the column is occupying other columns(or spiting) and it is causing the issue at type conversion .

    I have used same delimiter while importing the data. and there is no pipe delimiter in that column

    Data type of columns varchar(40).

    In CSV file also i am getting column miss match.

  • January 30, 2012 at 6:58 am

    #1439963

    Row delimiter (CR LF) in the column data?

    Column delimiter in the column data?

    -- Gianluca Sartori

  • January 30, 2012 at 7:10 am

    #1439970

    Row delimiter (CR LF) in the column data?

    ''New Line"

    Column delimiter in the column data?

    |

  • January 30, 2012 at 7:49 am

    #1439994

    I mean: did you check that row or column delimiters are not in the column data?

    -- Gianluca Sartori

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

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