Conversion failed because the data value overflowed the specified type error

• Surya V

  Newbie

  Points: 8

  More actions

  November 9, 2018 at 6:08 am

  #380805

  Hello,

  I'm loading MySQL table(view) data to SQLwhl database using SSIS package and Job.
  While loading data continuously I'm getting "Conversion failed because the data value overflowed the specified type error" even though the source and destination column data types are same.

  I'm using "MySQL Connector Net 8.0.12" for creating data source connection in SSIS package.

  I've used a data conversion component, RedirectRow and IgnoreFailure options, but that did not help.
  Let me know if you need any other information about the process I'm following.

  Any inputs in resolving this will be much appreciated.