Post reply

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

  • August 6, 2010 at 1:06 pm

    #140130

    :-)Please need help..

  • August 6, 2010 at 1:10 pm

    #1203755

    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.

  • August 6, 2010 at 1:48 pm

    #1203765

    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

  • August 9, 2010 at 5:55 am

    #1204087

    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