HEllo to ALl SQL guys, . I need help..

I am using a Foreachloop container and i have a bulk insert task inside it. Everything works fine, but the file connections seems to throw error during dynamic connection.

what i am trying to do is loop over a folder , find all .txt files and do bulk insert to sql table.

this works with dataflow task.

So my question, how can we do this when using bulk insert,.

? can someone help me? i get this error:- the connection"............" is not valid or pointing to an object that doesn't exists.

thanks

Thanks to All those who viwed it. I was able to finish this. There was a silly mistake on my part.

Solution: Although the file path is assigned dynamically during the run time, it needs a value to validate teh connection at the start of the task. My value for the variable--"filetoimport" was empty and it was giving eror because couldn't find the value for file connection.

Thanks