Invalid Path

[rittermd]

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];

[gainkarthi]

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.

[#3]

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