Date:         Mon, 15 Dec 2008 14:08:42 -0800
Reply-To:     oramcle <oramcle@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         oramcle <oramcle@GMAIL.COM>
Organization: http://groups.google.com
Subject:      sas DI
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I am creating SAS DI job for data transformation , I am getting data
from two different table table using SQL JOIN, creating a Surrogate
Key using Surrogate Key Generator and finally loading SAS Data SET
using SCD Type 2 Loader.
I am getting an error like this,

MPRINT(ETLS_SCDLOADER): data work.etls_source(drop=etls_str etls_md5);
ERROR: Write Access Violation In Task [ DATASTEP (2) )
Exception occurred at (038F48A6)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
038F48A6 036BEFC8 sassqlp:mcn_main+0x538A6
038CF2BB 036BF47C sassqlp:mcn_main+0x2E2BB
038CB37F 036BF524 sassqlp:mcn_main+0x2A37F
600E188A 036BF6CC sasesql:mcn_main+0x88A
671B2762 036BFC14 sasyoio:mcn_main+0x11762
671AF417 036BFD54 sasyoio:mcn_main+0xE417
672F7F88 036BFDEC sasdsa:mcn_main+0x6F88
672B9F72 036BFE74 sasdsc:mcn_main+0x8F72
67871CF3 036BFF04 sasxshel:mcn_main+0x30CF3
67871381 036BFF14 sasxshel:mcn_main+0x30381
672B1891 036BFF48 sasdsc:mcn_main+0x891
673111E9 036BFF88 sasds:mcn_main+0x1E9
01002B02 036BFFA0 sashost:Main+0xBE72
01006C20 036BFFB4 sashost:Main+0xFF90
7C80B713 036BFFEC kernel32:GetModuleFileNameA+0x1B4


I have all the Authorities to write in to this Data set and the
library
Any help in this regards will be appreciated.
I am using SASTRUST user
I was getting the same error when i am using target ORACLE table, so i
am using the SAS data set to see how this working , but i am getting
same problem.

Thanks
Ram