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
User contributions licensed under CC BY-SA 3.0