I am loading data from csv file to my sql table through SSIS. Is there any default limit specified on number of records to be read from csv file ?
While loading the csv file, my data flow component is processing only 5000 records, though it contains 5341 records,as shown in the image below.How can i fix this ?
Are you [mistakenly] swallowing error rows?
What have you got set in the source error output?