I am trying to bring over a calculated number field from sharepoint. When what I think the mapping should be:
<Field Name="Hours" SqlType="decimal(12,2)" SPType="Number" Required="false"></Field>
I get an error: System.Data.SqlClient.SqlException: Incorrect syntax near '#0'
So I setup the SQL type to varchar and the value of the Hours sharepoint field is, float;#0.5000000, or something like that.
Is there another SPtype I should be using for this?