I've been working on a large DI Studio job which tidies up historical data. Suddenly, all the connections have become invisible so that the job looks like a large collection of "isolated SQL Join islands". When I enter an SQL Join all the mappings still look correct, but when I try to run the job, the SQL Joins that use subqueries refuse to function.
Have any of you encountered a problem such as this before?
Yes and we had to re-build the job from scratch... raise with TS
Barry
I also had this problem after an Export-Import process. The original job do has the connections but the importe job do not.
Carlos
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.