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 'CONSENT_DATE', 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 220.127.116.11 and higher
This error occurs when importing consent records, but the Consent Date field is either not mapped or blank in the data file. If all the rows being imported have the same consent date you can use a Virtual Field to import this date, otherwise add a column for the consent date in the data file and populate with the date.
Refer to the ImportOmatic User Guide for additional information.