title: Error in SSIS when trying to move package from .txt to SQL Server
body: <p>I'm trying to move files from <code>.txt</code> to SQL Server and got these errors</p>
  <blockquote>
  <p>[OLE DB Destination [35]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.</p>
  <p>An OLE DB record is available.  Source: &quot;Microsoft SQL Server Native Client 11.0&quot;  Hresult: 0x80004005  Description: &quot;Invalid character value for cast specification&quot;.</p>
  <p>An OLE DB record is available.  Source: &quot;Microsoft SQL Server Native Client 11.0&quot;  Hresult: 0x80004005  Description: &quot;Invalid character value for cast specification&quot;.</p>
  <p>[OLE DB Destination [35]] Error: There was an error with OLE DB Destination.Inputs[OLE DB Destination Input].Columns[effdate] on OLE DB Destination.Inputs[OLE DB Destination Input]. The column status returned was: &quot;The value could not be converted because of a potential loss of data.&quot;.</p>
  </blockquote>