A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue.

Similar issue happened at our end whereas the SSIS package uses an application is using the SqlClient provider that will write big datachunks to SQL Server database and store in BLOBs using blobColumn.Write(...) using .NET 2.0 dbcommand object calling a Stored procedure, not a straight forward solution.

So the occurence of this error happened after recent Windows Update on the web server and other file servers associated in this package, one of them have had issues with Windows Update and stuck with MSI installer process where it is stopping all other connections when it is trying to complete the installation. TO resolve it we found the way is to reboot the relevant file server and any associated machines to clearup the cache. As usual on the basic information to troubleshoot you can use a netmon trace by getting it from http://support.microsoft.com/kb/812953/ link for more information.