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.

    Ray Elefano

      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:

      [Location_Coordinates]:

      LIB CONNECT TO [DATABASE_SERVER];

      LOAD [sitename],

        [latitude],

        [longitude];

      SQL SELECT  "name" as sitename,

        "latitude",

        "longitude"

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

       

      [VTable]:

      Load * from Location_Coordinates;

       

      I get the following error:

      The following error occurred:

       

      Invalid Path

       

       

      ---

       

       

      The error occurred here:

       

       

      [VTable]:

       

       

      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.