I have a package that copies data from a view from server A(sql server 12) and copies the date to server B(sql server 2005). included in the package is a derived task. the task has 4 transformation's, If run I run the package it hangs (all boxes yellow) and using a data viewer the transformations seem to work but no data is inserted into a table on server B.
If I take out all but 1 derived transformation the package completes, also because we have alerts set up on server B the following email is created:-
DESCRIPTION:A fatal error occurred while reading the input stream from the network. The session will be terminated.
COMMENT:(None)
JOB RUN:(None)
Has anybody got any idea's.