Step
SQL Server Destination/SQL Server Bulk Destination.
Message
Error Parsing record to row: Cannot convert string to number.
Cause
This error occurs when you specify a mapping to a numeric column (Decimal, BigInt, Numeric, etc.) but the source value is not a number. For example, consider this mapping on the SQL Server destination step:
| Path | Column | SQL Type | Length | Precision | Scale |
| --- | --- | --- | --- | --- | --- |
| @record.number | Value3 | Decimal | | | |
Now consider this record:
json
{
"number": "xyz"
}
If we try to parse this record through a step with the provided mapping, it will fail with this error because we cannot convert `xyz` to a number.
If, on the other hand, we had the record below, we would have no errors.
json
{
"number": "123"
}
Resolution
Make sure that the value that you are mapping to a number is a numeric value.
Error Detail
json
{
"message": "Invalid parsing record to row",
"statusCode": 400,
"errorMessage": "Cannot convert string to number"
}