Hi I am trying to read/select records from SQL server and insert/append the same records to a Teradata Table. When Using Mload Teradata Utility through 'DATA' Step in SAS. SAS Enterprise Guide crashes when it encounters MLOAD. SAS Version is SAS 9.4 TS Level 1M3 The Error meassage is “Read Access Violation APPEND (2) Exception occurred at (0A67F9EC)” The Code is ---------------------------------------------------------------------------------------------------- %let uid = xxx; %let pwd = xxx; OPTIONS sastrace=",,,d"; LIBNAME DUMMY TERADATA USER= "&uid.@LDAP" PASS="&pwd." mode=ansi server="DUMMY_SERVER" schema="DUMMY_SCHEMA"; LIBNAME DUMMY_SQL ODBC DSN="DUMMY" USER="&uid.@LDAP" PASSWORD="&pwd." SCHEMA="TEST_SCHEMA"; PROC SQL; CONNECT TO ODBC(DSN="DUMMY" USER="&uid.@LDAP" PASSWORD="&pwd."); CREATE TABLE WORK.INTERMEDIATE_TABLE AS SELECT * FROM CONNECTION TO ODBC(SELECT top 2000 COLUMN_1 FROM TEST_TABLE ); QUIT; DATA DUMMY.TARGET_TABLE(DBCREATE_TABLE_OPTS="PRIMARY INDEX(COLUMN_1)" MultiLoad=YES ML_LOG=TEST_LOG ML_CHECKPOINT=500); SET WORK.INTERMEDIATE_TABLE; RUN; -------------------------------------------------------------------------------------------------- Also, tried using TPT Utility too, faced the same issue DATA DUMMY.TARGET_TABLE(DBCREATE_TABLE_OPTS="PRIMARY INDEX(COLUMN_1)" TPT=YES MultiLoad=YES ML_LOG=TEST_LOG ML_CHECKPOINT=500); SET WORK.INTERMEDIATE_TABLE; RUN;
... View more