Unable to Change Table name in Query

[tstagliano]

We have a current TI process which pulls data from a 1 table with no issues. We are trying to point that query to a new table with the same fields that hold historical data, but when i change the FROM clause of the query to be the new table name, i receive the error message below.

"SQL Statement failed"

I am however successfully able to run that query directly on the SQL server with results.

Please advise.

[jim wood]

What ID are you using in the ODBC connection? Does it have access to the table? when you ran the query successfully on the server did you login as you or the user named in your TI?

[tstagliano]

Thank you Jim. The service account we are using did not have access to that table.

[jim wood]

It's a pleasure. I'm glad it's working.