title: Bad Data in Excel source does not generate error in SSIS
body: <p>I have a quick question regarding SSIS.  I am developing a package that performs a Data Flow task from an Excel Source into OLE DB Connection.  The columns in the database should allow nulls.  However there is a problem in that when I enter bad data into the numeric columns in the excel spreadsheet, it will not cause the Data Flow task to fail as I would like it to.  I tried to remedy this by explicitly trying to convert any numeric columns in the Derived Column step, however the same thing occurs-- if I enter abc into the Excel numeric column, if just turns out as NULL in the db after the package runs.  I do want to allow for NULLS, but I'd like the package to fail if the data is corrupt.  </p>
  
  <p>Any advice would be appreciated :)   </p>