title: Error Output in SSIS
body: <p>I have a 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 contain some EMPID, Name, salary. However there is a problem in that when I enter bad data into the numeric column i.e Salary and Name in the excel spreadsheet, it will not cause the Data Flow task to redirect the false data as I would like it to. For Example If I enter "abc" into the Excel numeric column AND "123" in the Name column, It will not redirect the False Data even it stores all the data. I do want to allow this, but I'd like the package to redirect the False Data in some excel file. Please suggest. And if you provide screenshot with every step then it would be more helpful for me.</p>