Error converting data type nvarchar to numeric

[Anonymous]

I am getting error as "Error converting data type nvarchar to numeric" when I am trying to extract data from a CSV file using dynamic schema and load it to target table in db.I have already checked with the datatype in target table and source table, it's the same.

My job is running correctly for all steps and I am getting correct output in a CSV file but getting the above error while inserting into target table.

[manodwhb]

@shrath , As part of your data may be it have some string characters ,because of which when you are loading into  table it is giving this error.

[Anonymous]

@manodwhb , My data has all the numeric values but I am getting the same error

[manodwhb]

@shrath , can you share your component screenshots of schema of csv and database and let me know which column is that?