Issue while Inserting/Appending Records in Teradata Table through SAS

[RahulG1]

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;

[JosvanderVelden]

Which OS?
Have you read the paper: http://support.sas.com/resources/papers/teradata.pdf

[RahulG1]

The OS is windows

Windows Version 6.2.9200

Thanks for the paper, I have gone through this. The problem still persists