Post reply

Error: 4014, Severity: 20, State: 2." on SSIS Dataflow job Step

  • August 19, 2008 at 2:15 am

    #125736

    I have an SSIS job that has been running fine every hour until last week.

    Occasionally I get the following error:

    Error: 4014, Severity: 20, State: 2." A fatal error occurred while reading the input stream from the network.

    My environment is SQL 2005 and Windows 2003 x64 Standard.

    If someone does have ideas to resolve this please.

  • August 19, 2008 at 2:54 am

    #859852

    [font="Verdana"]Check the link below

    http://sqlserver-qa.net/blogs/perftune/archive/2007/10/01/2284.aspx[/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • August 19, 2008 at 3:09 am

    #859855

    Thanks. I did try that but its seems like it not working. The package is still failing. but if I execute the job manually is runs fine.

  • October 4, 2009 at 8:04 am

    #1061459

    Hi there,

    I have the same issue.

    Running the SSIS package manually works fine. Running the same package based on a schedule, the same error happens.

    I fought it could have something to do with pushing performance boundries. Possibly other jobs are interfering (on SAN for example). I am however not sure.

    Did you find a solution?

    Kind regards

    dave4you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply