Communication link failure error while running a SQL agent job in SSIS

0

We are getting communication link failure error for a direct loading package in SSIS frequently with errors like
1)

Shared Memory Provider: Timeout error [258]. Code: 0xC004701A and failed the pre-execute phase and returned error code 0xC0202009.

2)

Shared Memory Provider: Timeout error [258]. Code: 0xC002F210. 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.

any suggestions regarding this issue will be greatly appreciated.

Thanks in Advance

sql-server
ssis
asked on Stack Overflow Jun 27, 2017 by Undeti Upendar • edited Jun 27, 2017 by Prabhat G

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0