I am creating a package through SSIS. when I try to import the csv file in sql table by using the DataFlow-->Flat File Source-->OLE DB Destination, it is working fine for this format.
but when the csv format like this
it throws an error message, due to second row is incomplete.
So the question is how we can eliminate the row which not contains the complete column.