Communication Link Failure

Question

Hi,

I have a package with a few data flow tasks. One task has a sql command where i exec a sp with parameter. When i go to the mapping i get the error:

Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".

The thing that baffles me is that it was working fine and suddenly i get this error. I am working locally.

What could be the problem?

Thanks

Answer 1

Hello Collie12,

please have a look

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fab0e3bf-4adf-4f17-b9f6-7b7f9db6523c

Hope it will help!!

Answer 2

Thanks

The link didn't help me. I recreated the package.

Answer 3

Hi,

After you recreated the package, does the phenomenon repro?

In most cases, when you met the error message while executing an query in package, you can try the below KB article which outlines that TCP Chimney may be the cause.  Turns out, TCP Chimney may require an update the your NIC drivers.  

http://support.microsoft.com/kb/945977

Or you can disable TCP Chimney to eliminate the error.

To disable, see following command. (Restart not required):

Netsh int ip set chimney DISABLED

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

Hi,

So far the package is working. I will look at the article you provided.
Thanks :-)