When inserting data into a SQL Server column with the BCP option and not explicitly specifying the literal value in the INSERT statements, you receive the following error:

  ERROR: Error binding parameters: [Microsoft][ODBC SQL Server
  Driver]Attempt to bulk-copy a NULL value into a Server column which
  does not accept NULL values
  ERROR: ROLLBACK issued due to errors for data set
  MYDB.cwddefault.DATA.

For example, the table definition for CWDDEFAULT is as follows:

This SAS code generates the above error.

This will be fixed in SAS 9.2. The current workaround is to use a literal "0" inside the select statement. For example:

  proc sql;
  insert into x.cwddefault(col1, col2) select col1, 0 from foo;
  quit;

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :