Job gets aborted while loading data in to SQL server Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Hope
Participant
Posts: 97
Joined: Sun May 13, 2007 2:51 pm
Contact:

Job gets aborted while loading data in to SQL server Stage

Post by Hope »

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.
wesd
Participant
Posts: 22
Joined: Mon Aug 16, 2004 8:56 pm

Post by wesd »

Try using type Numeric in SQL Server instead of Decimal.
Wes Dumey
Senior Consultant
Data Warehouse Projects
Post Reply