Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

How to get SSIS project to skip bad records and insert good records so entire project does not fail?

I have a series of SSIS projects that have been running happily for months. Suddenly a few are failing. The error message is column delimiter for column 'XYZ' is missing. The input file is a csv file. I checked the structure of the input file and it is fine. I am suspecting that bad characters are in the input file. All I have in the Data flow section of this project is Read CSV file(flat file source) and write to a SQL table(OLE DB Destination). What should I add to this project to be able to find the bad data or at least have it skip the bad records and write the good records?
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rwheeler23

ASKER

Thanks
Welcome..