I am trying to insert a data in SQL server table using SAS Below is the code that I have written %macro lzlib; LIBNAME LZZ OLEDB BULKLOAD=YES DBCOMMIT=0 CURSOR_TYPE=STATIC BL_KEEPIDENTITY=YES BL_KEEPNULLS=NO DIRECT_EXE=DELETE PROPERTIES=('Integrated Security'=SSPI 'Persist Security Info'=TRUE 'Initial Catalog'=Customer_account) PROMPT=NO REREAD_EXPOSURE=NO PROVIDER=SQLOLEDB DATASOURCE="dwh-i-sql" SCHEMA=DZS ROWSET_SIZE=32767 UPDATE_MULT_ROWS=YES PRESERVE_GUID=yes; PROC SQL; INSERT INTO LZZ.CUST_DIM SELECT DATO ,JOBNAME ,RUNDATE ,EXECUTION_STATUS ,COMPARE ,LcOMPARE_RESULT ,OUTPUT_FLAT_FILE_EXISTS ,FOLDER_LINK ,FILE_NAME ,ADD_INFO ,FILE_EXISTS ,HOST_FILE_DOWNLOAD ,FILE_READ ,HOST_FILE_READ ,COMPARE_PROCEDURE ,COMPARE_STATUS ,BASEDATASETOBS ,COMPAREDATASETOBS ,BASEDATASETVAR ,COMPAREDATASETVAR FROM FINAL; QUIT; %mend; This is the error that comes up ERROR: Execute error: IRowsetFastLoad::InsertRow failed. : Unspecified error ERROR: ROLLBACK issued due to errors for data set LZZ.CUST_DIM.DATA. Thanks!!
... View more