We have a File landing zone, where flat files land twice a month. I need to grab those FF file and process it and dump into sql tables. I was wondering If I could get some inputs on how to validate the incoming FF like its not zero bytes or any other validation checks in SSIS ..I would really appreciate if you could give me some ideas/tips on proceeding fwd .
Thanks for reading this..
Thanks,
ashy