3 Replies Latest reply: Feb 23, 2016 7:59 PM by jagan mohan rao appala RSS

    Populate temp table from a table that was just loaded.

      I'm trying to load a temp table with data from another table, via the Data Load Editor, but I'm getting an error.


      Here is my code:



      LOAD [sitename],



      SQL SELECT  "name" as sitename,



      FROM "DATABASE_SERVER"."dbo"."locations";



      Load * from Location_Coordinates;


      I get the following error:

      The following error occurred:


      Invalid Path






      The error occurred here:






      Load * from Location_Coordinates
      I also tried populating the temp table in another script, but that didn't help.
      I can see that Location_Coordinates is populated correctly via the data manager.  So I'm not sure what the issue is.