Description: This solution describes how to resolve the Error: General ODBC Error: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert the value NULL into column 'RESPONSE', table 'RE7_Sample.dbo.ConstituentContactConsent'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The statement has been terminated.
Versions: RE 7.96 patch 8 and higher and IOM 184.108.40.206 and higher
This error occurs when importing consent records, but the Response field is either not mapped or blank in the data file. If all the rows being imported have the same response you can use a Virtual Field to import this data, otherwise add a column for the response in the data file and populate with the response.
Refer to the ImportOmatic User Guide for additional information.