The given value of type String from the data source cannot be converted to type bigint of the specified target column.

  • :-)Please need help..

  • Hey who starred in that movie last year you know the one with the guy that liked the girl?

    Provide some more information and we will be happy to assist where we can.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • Sigh. What exactly are you trying to do when you get this message? The message itself is pretty clear about the problem. At leaast one value of the data in a column in your data source that is defined as a string has data which cannot be converted to the integer data type. Could be 'AAAAA'. Could be '24.672'. The only thing to do is examine your source data for the invalid value. If you're asking for tips on how to do that, the answers will depend on whether your source data is in a database table or in a flat file or something else.


    And then again, I might be wrong ...
    David Webb

  • use cast or convert function

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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