HI..
I have one excel file which is having dimensions meta data info in each sheet (One dimension info in each sheet) with same format. Sheet name having the dimension name.
Now, i want to access these sheets and load into my target table(look up on sheet name and target table name).
So, i need to perform 2 tasks now.
1) Loop thru all sheets in excel and
2) Save the sheet name in variable each time, using this variable to look up on target table name .
Can anyone help me to achieve this?
- Changed type SSISJoostMVP, Moderator Friday, February 13, 2015 7:25 AM More appropriate type