DSXchange

I have a source (Flatfile). I am copying the data from source to a SQL server table.The datatypes in source are Varchar
and in Target they are Nvarchar an Decimals.where ever there is a decimal I used stringTodecimal conversion.
The job gets aborted with the following error.

SQLServer_Enterprise: [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '<'.
[Microsoft][SQL Native Client][SQL Server]Error converting data type nvarchar to numeric.

[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '<'.
[Microsoft][SQL Native Client][SQL Server]Error converting data type nvarchar to numeric.
[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '<'.
[Microsoft][SQL Native Client][SQL Server]Error converting data type nvarchar to numeric.
[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '<'.

In the table the options I am using are
Autogenerate Upsert SQL.
Insert in to Table
UpdateSQL
Upsert Mode=Insert then Update
Write method is Upsert.

Please help.

Try using type Numeric in SQL Server instead of Decimal.