There's likely to be other error messages in the logs. That particular error (an error in ProcessInput) typically indicates that the rows arriving at the Union All transform were unexpectedly stopped. The cause of that stoppage is likely another error (upstream) which will have been reported earlier in the log. Talk to me now on

I have several packages that have been running through the Job Agent (file system packages), and without changing anything, the job fails with the following information: Code: 0x80004005 Source: Export Transactions SSIS.Pipeline Description: Unspecified error End Error Error: 2011-09-09 09:30:16.71 Code: 0xC0047022 Source: Export Transactions SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Union All" (5710) failed with error code 0xC0047020 while processing input "Union All Input 2" (12562). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2011-09-09 09:30:17.26 When I run the packages in debug mode in BIDS, they work fine, no problems with it. Does anyone have any idea what is going wrong here? Thanks.-

I assume, the account of the SQL Server Agent or the Proxxy Account does not has permissions on the source of "Input2"