OlE DB Source - Cannot Acquire Connection From Connection Manager

My source files are in C:Process folder. File names are in the format proc*.csv

I am using foreach loop container to iterate over the files in folder "C:Process"

I have a user variable "filename"



The order of my tasks

ForEach - Data Flow task - File System Task



In Data Flow task, I have ole db source which should take the dynamic filename from user variable "filename". whats happening is when i give fixed filename, without foreach loop container the package is working fine.

with dynamic filename, I am not able to run the package because of ole db source Error - cannot aquire connection from connection manager.



Thanks for u'r help.