Hi,
I am trying to load data from CSV file into SQL tables using SSIS package.
In ideal scenario the file should have Carriage Return and Line feed. But we are receiving files with Line Feed only, Carriage Return only and sometimes with no Carriage Return and Line Feed. In these scenarios the package did not failed but data was also not loaded in SQL tables.
Please let me know how to fail the package.