I have a temp output file in EG 9 that is the end product of a series of queries. I need to use that output to populate a table in SQL. My script seems to be running except for this irritating error msg:
ERROR: Execute error: ICommand::Execute failed. : Invalid object name 'WORK.TEST_FOR_SQL_OUTPUT'
'WORK.TEST_FOR_SQL_OUTPUT' is the file name of the temp output file. I've tried just 'TEST_FOR_SQL_OUTPUT' but get the same msg. Right now my code is in a code node within the project, but I even tried embedding it in the code for the final query, but I always get the same message.