2 Replies Latest reply: Apr 28, 2016 4:03 PM by uday kumar RSS

    Invalid Path

    Mark Ritter

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