uzn2010 (7/25/2016)
My SSIS package fails using Sql Server Agent Job. When i execute the package manually from the Sql server MSDB package store, it runs fine but when i try to schedule it with job it is showing this error." 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 DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:47:02 AM Finished: 10:47:09 AM Elapsed: 6.141 seconds. The package execution failed. The step failed."
And the proxy account i'm using to run this job does not have any credentials attached to it, how important is to do that
This bit
There may be error messages posted before this with more information about the failure.
Is usually true – ie, there are probably other error messages which will contain more-specific details which may be of assistance. So I suggest you start there.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.