title: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR
body: <p>I got this strange error message I couldn't get rid of no matter what i tried. It is an SSIS package developed using Visual Studio Prof. 2012 and database is SQL Server 2012.</p>
  
  <p>Message reads this: </p>
  
  <blockquote>
    <p>[OLE DB Source [85]] Error: SSIS Error Code
    DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "OLE DB Source.Outputs[OLE
    DB Source Output].Columns[ProductionMultp]" failed because error code
    0xC0209075 occurred, and the error row disposition on "OLE DB
    Source.Outputs[OLE DB Source Output].Columns[ProductionMultp]"
    specifies failure on error. An error occurred on the specified object
    of the specified component.  There may be error messages posted before
    this with more information about the failure.</p>
  </blockquote>
  
  <p>This happens at the time of creating source data in OLE DB Source Editor. I tried to convert source data to the right data type needed in the destination within the source sql command, I tried to the conversion using Data Conversion tool in SSIS, I tried to use both with no avail...</p>
  
  <p>Anybody familiar with that sort of message???</p>
  
  <p>By the way, there is no NULLs in the data nor any value is greater than allowed number of digits in given data type...</p>