I have a relatively simple SAS DI studio job that reads from an Oracle view and writes to a SQLServer table. The SQLServer table I'm inserting into has spaces in the column names. The table in in a 3rd party database so I cannot rename the columns. This is the error that I get. Line 255: ERROR: CLI execute error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'ID'. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'Date'. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared. This is the statement that is failing. It doesn't like the "Personnel ID"n column name (and others with spaces) insert into scmms."tmp_Personnel"n ("Import_PersonnelID"n, "ImportError"n, "Name"n, "Personnel ID"n, "Display Name"n, "Honorary"n, "Initials"n, "Reference"n, "Job Title"n, "Extension"n, "Telephone"n, "Mobile"n, "Home Phone"n, "Email Address"n, "Fax"n, "Pager"n, "Geography Selection"n, "Site"n, "Location"n, "Unit"n, "Partition"n, "Start Date"n, "End Date"n, "Division"n, "Department"n, "Grade"n, "Authorisation Level"n, "Allocation"n, "Cost Code"n, "Registration"n, "Export Value"n, "Post Box"n, "Show Message"n, "Messages"n, "Remarks"n, "Event PO Authoriser"n, "Fire Warden"n, "First Aider"n, "Has Secretary"n, "Stock PO Authoriser"n) select "Import_PersonnelID"n, "ImportError"n, "Name"n, "Personnel ID"n, "Display Name"n, "Honorary"n, "Initials"n, "Reference"n, "Job Title"n, "Extension"n, "Telephone"n, "Mobile"n, "Home Phone"n, "Email Address"n, "Fax"n, "Pager"n, "Geography Selection"n, "Site"n, "Location"n, "Unit"n, "Partition"n, "Start Date"n, "End Date"n, "Division"n, "Department"n, "Grade"n, "Authorisation Level"n, "Allocation"n, "Cost Code"n, "Registration"n, "Export Value"n, "Post Box"n, "Show Message"n, "Messages"n, "Remarks"n, "Event PO Authoriser"n, "Fire Warden"n, "First Aider"n, "Has Secretary"n, "Stock PO Authoriser"n from &etls_lastTable ; If I take out the column names with spaces, I do not get the error. But I need to provide data in these columns. In the table definition, I have the "Enable special characters within table or column object names" selected. See attached image file for more details regarding table definition. Environment details SAS 9.4 on a Linux server DI studio 4.901 installed on Windows 10. As a test, I copied the job back into our old environment. SAS 9.3 Windows server DI studio 4.6 installed on Windows 7 and everything works fine. Is there some server configuration that we need to adjust? Patches? Let me know if there is anything else I can provide that would help.
... View more