I have lose 2 days trying to understanf the following error:
I have a master package with several child ones. When I execute the master one of the child packages suffers an error in a Data Flow Task when executing a Loojup component:
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Retrieve Activity" (894) failed with error
code 0x80070057 while processing input "Lookup Input" (895). 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.
The same child package where the error appears contains other lookup tasks that are executed properly.
Surprisingly when the child package is executed alone the error does not appear and the package executes properly.
I have lost 2 days comparing the tasks with other ones and checking properties and I haven't found the clue. I have found in the forum a similar post with a related problem but I don't know how to fix my problem
If someones has any idea it will
View Complete Post