OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties.

Community Notes

Add your experiences and workarounds here. If you have solved this issue, why not help the next person?

ComponentErrorCodes

This is related to caching issues found with SQL Integration service.

http://onlytalkingsense.wordpress.com/2006/06/06/ssis-lookup-caching-problems/

Another one is

http://blogs.conchango.com/kristianwedberg/archive/2006/02/22/2955.aspx

which talks about gotchas you need to be careful of before using lookup transformation.