Ssis

[C# Programming]

Hi all,

Hope this is in the correct forum. I have an issue with some work I am involved in. We have a flat file we are loading into an MSSQL database which is failing on the insert because the original flat file contains suspect data. Invalid dates or values etc. We are using SSIS to load this data. Can someone tell me if it is possible to exception these records easily.

requirements are
- to identify the number of records with the problem
- to identify these records
- to manage the issues which error

I am a project manager and do not want the wool pulled over my eyes. I am familar with C# and SQL server but have only seen SSIS over a shoulder of a developer.

I believe this would be a simple change and would be a matter of minutes to resolve. I am currently being led to believe it is hard.

Thanks all