title: SSIS ERROR "Conversion failed because the data value overflowed the specified type"
body: <p>I'm using ssis to parse file txt into sql server. I use script task to convert a string example <code>"20190523100520"</code> (type :yyyy-MM-dd HH:mm:ss) to datetime (it's data type in table sql ).</p>
  
  <p>But I get the error: </p>
  
  <blockquote>
    <p>[OLE DB Destination [68]] Error: "There was an error with OLE DB
        Destination.Inputs[OLE DB Destination Input].Columns[NewEffectiveTS_NXX_X] on</p>
    
    <p>OLE DB Destination.Inputs[OLE DB Destination Input]. The column status 
        returned was: "Conversion failed because the data value overflowed the specified type.</p>
  </blockquote>
  
  <p>In script task, tag inputs and outputs, i use database timestamp <code>[DT_DBTIMESTAMP]</code> type for Columns <code>[NewEffectiveTS_NXX_X]</code></p>
  
  <p>Everyone help me. Thank you so much!</p>