Communication Link failure when running the SSIS package from JOB

I have a SSIS package which runs successfully in BIDS but when I try to run as a job it gives the below error. From trace file we identified one query which takes more time and tried to tune it using CTE but still it throws same error. Other similar packages are running fine from job. Please help to resolve this issue. Executing the query "SELECT COUNT(DISTINCT STL_ID) CONTRACT_COUNT FROM ..." failed with the following error:"Communication link failure". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Mar 21, 2017 at 03:24 PM

How long does the query take to run? is it possibly a timeout issue?

0 ·

Selvam786 commented · Mar 22, 2017 at 07:02 AM

Thomas, Thanks for your reply. It's not a time out issue.It's a connection failure happens as the query runs for longer time. But the same package runs fine from BIDS and spins for long time from job.

0 ·