the error because of a potential loss of data

• ColinChen

  SSC-Addicted

  Points: 414

  More actions

  May 27, 2008 at 9:10 pm

  #154388

  [OLE DB Destination [306]] Error: There was an error with input column "adj_chgs" (464)

  on input "OLE DB Destination Input" (319).

  The column status returned was: "The value could not be converted because of a potential loss of data.".

  How to fix it?

  C.G

• kbatta

  SSCrazy

  Points: 2274

  More actions

  May 28, 2008 at 8:16 pm

  #821541

  What are the formats and sizes of the input column and the output column? This is usually where the problem lies.

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  May 29, 2008 at 1:44 am

  #821627

  Hey Colin,

  This normally happens when the size of your destination is set to for example 10, but the size of your source is set to 15.

  Easiest solution is to ensure that your source and destination have the same sizes

  ~PD