Post reply

SSIS project

  • July 10, 2008 at 4:45 pm

    #184504

    I'm transfering data from one SQLServer table to another in the same database with an SSIS package. This is the error message I am getting. Any suggestions as to why it may be failing?

    Msg 8115, Level 16, State 8, Line 3

    Arithmetic overflow error converting numeric to data type numeric.

    The statement has been terminated.

  • July 11, 2008 at 5:21 am

    #841359

    You have a number being transferred into a field that is too small. Something like trying to put a BIGINT into an INT field. It will probably be a numeric in which you have the scale and precision set wrong.

    Re-check all of your data types to make sure you are not putting 10 gallons into a 1 gallon bucket.

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

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