Fixed this error by changing the datatype in my DataTable (source) column to System.Decimal. I believe the database datatype Numeric wanted this.
DataTable table = new DataTable();
DataColumn idColumn = new DataColumn();
idColumn.ColumnName = "id";
idColumn.DataType = Type.GetType("System.Decimal");
table.Columns.Add(idColumn);
