Yes the service is running and i did try with IP and port number but no luck 🙁 browser services are running as well.

i did even try with powershell script and i get the same message for DCOM and Perlib 🙁

I passed it as a Read only variable and it worked thank you for your reply

in SSIS of course

its working ok with ORDER BY and the same results are been returned...

what does that mean though? that you always have to insert ORDER BY ?

see attached

there you go

Was in a rush my mistake check now. Any ideas or help much appreciated

attached the estimated plans

Well I know I made the mistake but this the query please forginve me if I put a wrong letter somewhere will send you in a moment the plans

SELECT

RTRIM(Ax) AS A,

RTRIM(Bx) AS B,

RTRIM(Zx) AS Z

FROM TEMP1 A

LEFT OUTER JOIN TEMP2 B on A.Zx = B.Zx

GROUP BY A,B,Z

Thank you both for your help

So Sorry was in a rush and dint explain it properly.

The errors that i have originally mentioned are staying the same, although i have narrowed down to only the...

I found out when i refer to an instance name inside the SSIS package it doesnt work when you deploy the package in sql job although in Studio is fine....

Yes it is a local admin and sys admin on the instance does it need something else as well ?