• Since moving two Databases and several SSIS Packages I'm having issues with the AS400 iSeries and I'm getting Communication errors.

    Several task fail. It seems that the task complete much faster and as if the AS400 can't keep up with it.

    Should I limit the number of processors?

    If I limit the number of parallel loads, SSIS Tasks, I have been able to avoid the error.

    I have 1 64 bit Windows Server 2008 R2 running SQL Server 2008 R2.

    I looked it up on BOL but I have never had to mess with changing the number of processors.

    Any ideas would be greatly appreciated.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/