Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I keep getting invalid path when I try to run this part of the script. The problem is with the concatenate part. But I don't see what is wrong.
I can run a regular load of the table in another dashboard with no errors.
I also commented out the 3 lines and changed to Load * and got the same error
Section Access;
Load * INLINE [
ACCESS,USERID,CUSTOMERID
USER,WIN-IVTIROI5TAF\mritter,16
USER,WIN-IVTIROI5TAF\mritter,18
USER,WIN-IVTIROI5TAF\mritter,40
USER,WIN-IVTIROI5TAF\testuser1,40
];
LIB CONNECT TO 'Production (win-ivtiroi5taf_kflynt)';
CONCATENATE
LOAD
'USER' as ACCESS,
'WIN-IVTIROI5TAF\' & UserID as USERID,
LocID as CUSTOMERID
FROM
[dbo].[UserLocPermission];
This should be the issue with the connection. Not with the script's syntax.
Select some tables from the connection icon itself to see if it's pulling data from the source.
you have setup path same like above mentioned. if im not wrong you are trying to open app developed in other machine . Thats why oyu are getting this error