Hi Experts,

I have the same problem., I used excel sheet as source to use cache transform and could not able to execute it. The same data works fine when using flat file. This could be a problem in SSIS design.

Am using WIN 7 64 bit. So , i have set Run64bitruntime to False and checked Delayvalidations as true. Still the problem is same.

I will try again with .xls format and post back if it executes successfully.:-)

Thank you

Vijayvanamala