Hi,
In my new project while I am transferring data from an Excel sheet to a SQL Database table, and have set the error data to be redirected to a flat file, I have deliberately set 56 out of total 366 rows to have one column with a size greater than that of a field. But when I run the project I get 3 Green Check marks on the Excel Source, OLE DB Destination & Flat File Destination and the blue line reflects 366 records to be transferred. Upon checking in the SQL DB's table I find only 310 records to be successfully transferred but the Flat File to be empty?
Any specific reason and way to resolve the same?