Passing multiple URL's in Sharepoint List Source Exprression

Nov 17, 2013 at 6:05 PM
Please help me on how to pass the multiple URL's to the Sharepoint list source. I have refered the following link but the steps are not given clearly.

1) I have all the subsite url's in SQL table.
2) I am retrieving it using Execute SQL task and storing the URL in variable.
3) Created data flow task inside the for each loop container.
3) Assigning that variable as expression to Sharepoint List Source.SiteURL not working.
4) I have tested by entering the Site URL in variable value, then it is working fine.
5) but passing dynamic URL to the Sharrepoint list source is not working.
6) FYI... The site list name and metadata is same for all URL.

Please help.....
Nov 17, 2013 at 6:53 PM
I have referred few threads related to it but not finding the exact steps to be followed to set up the expression for SiteURL. So, please help me by providing the exact steps to be followed.