Hy,
I am getting error when executing the job. I got Proper records in data validation transformation but when i am running table loader showing records 0,
Kindly check this Image and let me know what is the error ?
Thank You
with warm regards
Shakti
Kind of late reply, so I hope you got your problem solved 🙂
Nevertheless, it's very hard given this information to help out.
First of all, what erro do you got?
A log entry will definitley help.
Do you have any constraints on the target table?
What update technique do you use?
Hy,
There is no Error in log. Log is Empty. but Table loader is successfully run.
No log at all?
Weird.
What happends if you run in batch mode, do you get a log then? And what return code for the job do you get then?
What I'd be doing in such a case is to copy/paste the DIS generated code into an EG program node and run it from there - eventually step-by-step.
Using EG will also allow you to easily access all intermediary work tables created.
I find it hard to believe that there is no SAS log at all. Is that also the case when running out of EG?
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.