The adapter “SQL” raised an error message. Details “HRESULT=”0x80040e07″ Description=”Error converting data type nvarchar to numeric.”
%ufeff<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>”.
I was trying to insert nothing into a field defined as a decimal.
I ended up changing it to varchar(21) and it worked fine.