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.
Job gets aborted while loading data in to SQL server Stage
Moderators: chulett, rschirm, roy