rwheeler23
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome..
ASKER