Yes exactly... It was a requirement from the client to avoid the usage of Objecttype variable and additional ESQL tasks if possible.Bhavana

Hi, We have a requirement to loop through a list of values stored in a table in our SSIS package to perform certain tasks. Currently we are using ESQL tasks to get list of values followed by For Each Loop Container (ADO enumerator) to loop over the lists. Is there a possibility to populate the list of values in the FELC and avoid the use of ESQL task? Please suggest. Thanks in advance Bhavana

Since your data is in table so you have to use execute sql task to save it in a variable and then use For each loop to iterate through the object variable. I think your approach is correct and no need to take execute sql task out of the equation.Nitesh Rai- Please mark the post as answered if it answers your question

Hi, Thanks for your response. Actually the requirement is to get rid of the ESQL task and populate values in FELC (To reduce the number of tasks used in the package) Any suggestions on how this can be achieved?Bhavana

Actually the requirement is to get rid of the ESQL task and populate values in FELC (To reduce the number of tasks used in the package) It means you want to fetch the values from table and iterate through those values using a single for each loop container. I think this is not possible. Any specific reason for getting rid of execute sql task and having an upper limit on number of tasks in the package?Nitesh Rai- Please mark the post as answered if it answers your question