I have a for each loop container and inside this I have a SQL task to execute a stored procedure. This stored procedure needs a parameter to be passed. This parameter have to be supplied from the text file. Can any one help me to use foreach loop container for this purpose.?

tell us what you want to do exactly? Do you want to loop through row of files and execute a stored procedure with each row value? if yes, data flow can be better to do this. if you want to do anything else explain morehttp://www.rad.pasfu.com