Desktop productivity for business analysts and programmers

"Invalid Object Name" error

Reply
N/A
Posts: 0

"Invalid Object Name" error

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.

Can anyone help?
Ask a Question
Discussion stats
  • 0 replies
  • 211 views
  • 0 likes
  • 1 in conversation