Excel Task -- Results Variable data type

[Leigh Anne Duvall]

I am trying to use the CozyRoc Excel Task for the first time.I created a variable of data type Object named User::WorksheetList. In my "General" tab, I have the Action set to "Get worksheets list" and the ResultVariable set to "User::WorksheetList." I'm using a static workbook connection just for testing. I then created a variable of data type String named User::WorksheetName. I dragged a For Each Loop beneath the Excel Task and I have the Foreach Loop Editor Enumerator set to "Foreach ADO Enumerator" with teh User::WorksheetList object bariable as the source and "Rows in the first table "as the Enumeration Mode. I then went to the Variable Mappings page and set the "User::WorksheetName" as the Variable with index 0. My assumption was the Excel Task would write a list of the tab names, but it's not doing that. I added a breakpoint and a watch to see the exact variable it's getting set to. The "User::WorksheetList" evaulates to "Dimensions:[92]" I do indeed have 92 tabs. However, I don't know how to get those tab names to be stored. I'm attaching screenshots of what I have set up. I woul really appreciate any help. I've read through everything I could find on http://www.cozyroc.com/ssis/excel-task

[Ivan Peev]

Hi Leigh Anne,

Change the For Each Loop to Foreach from Variable Enumerator and everything will be fine from there.