This is a tricky and elusive error that is showing up now and then in a SSIS job. The full text of the error is, “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.”
A colleague pointed out this article, that came up thanks to the Google overlords. While it was wrote for Server 2003 it lead me down the rabbit hole where I found a few posts indicating TOE/Chimney can be a problem with Server 2008.
That lead me to this page coving TCP Chimney offload. The feature attempts to offload TCP connections to the network adapter and, according to at least one MS guy, can be a bit dodgy. I’m looking to see if that offloading is happening during the SSIS job. I’m using netstat, run from an elevated command prompt, to write the state of the active connections to a file every 60 seconds
netstat -t 60 > C:\temp\netstat.txt
Proto Local Address Foreign Address State Offload State
TCP 10.10.1.37:135 10.10.26.168:54637 ESTABLISHED InHost
Here’s hoping that something interesting is logged tonight that will help put a stop to DTS_E_PRIMEOUTPUTFAILED.
It’s not a TCP Chimney offload problem which is too bad for a few reasons. One, it’s a new problem to me and I like to solve new problems rather than figuring out I made the same mistake again. Second and more important, the problem is still out there.
The logging for netstat -t showed no offloading to the NIC. What would have been better and faster would have been to run
netsh int tcp show chimneystats
This not only shows me that nothing was offloaded, PMAX = 0, but offloading isn’t even supported, Supp = No. That would have saved me a bit of time if I had used this first. Didn’t solve anything, but I did learn something so it’s not a total waste.