Once again this morning, the job failed and has continued to fail. I tried the below as well as a try catch and both are yielding the same result. I'm...

Thanks all, appreciate the feedback.

I did try pulling out the synonyms to simplify the troubleshooting and still ran into the same issue while it was broken. For now, my...

Yes, all queries went through. The interesting part is the query I am using is working. but its intermittent.

Once again I apologize.

All synonyms are pointed to the same server and created as follows. Of course replacing the appropriate table name where required.

CREATE SYNONYM [etl].[AFKO] FOR [SAPETL].[ERP].[erp].[AFKO]

Sorry yes, synonyms were used.

etl is the schema.

table synonyms are used for the following tables.

S022

PLPO

AFPO

AFKO

synonyms are pointed to the linked server.

Lined server is connected via Symbols.

Thanks for the response.

While working with that "software" has its... um, challenges, we are forced to work with it. 🙂

The interesting part now is that the Job has run...

I'll use a smaller set of data. Say I have the a table of Cases with the following columns. Id, Date, Name. What I would like to do is gather...

Do you mind providing an example?