Step
SQL Server Bulk
Message
Invalid column type from bcp client for colid {x}.
Cause
One of the entities being inserted into the SQL database contains a ```null``` field for a column that is set as not nullable on the database server.
Resolution
Consider whether the column in the SQL database must be nullable or not. If the requirements of your data are such that it can be nullable, consider changing the database schema to allow ```null``` values.
If the column being not nullable is more sensible, data validation needs to be implemented in the flow to check for ```null``` values on fields that can not be ```null``` in the database. A Calculator step is a suitable way to implement this validation functionality. Consider a suitable default value that can be inserted into fields that are ```null```.
Error Detail
{
"message": "Invalid column type from bcp client for colid {x}.",
"code": "EREQUEST",
"number": 4816,
"state": 1,
"class": 16,
"serverName": "{some-server}",
"procName": "",
"lineNumber": 1
}