SQL query problem - Need Help
My project's aim is to receive a DBF file, to transform it in a XML file and to store the data in the database. I'm making the DBF to XML transformation using a DBF2XML converter. Everything seems to be ok, but then I have some problems:
I've developed a project which receives a message about customers, transforms it and sends to the SQL Server via SQL Adapter.
Then the message is suspended and I get the following error:
The adapter "SQL" raised an error message. Details
"HRESULT="0x80040e07" Description="Error converting data type nvarchar to numeric."
<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80040e07" Source="Microsoft OLE DB Provider
for SQL Server" Description="Error converting data type nvarchar to numeric."?></Root>".
Can anyone help me with this error?
I guess the schemas and orchestration are correct, I verified it many times.