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.