Problem looping through excel workbooks(sheets) in a excel file in ssis

Hi i am new to ssis and i am trying to transfer data from excel file with multiple workbooks(tables) to oledb destination......i followed the instructions given in msdn but they r vague and do not help in achieving the result pls help me...

Quote:

Originally Posted by ashwinkpes

Hi i am new to ssis and i am trying to transfer data from excel file with multiple workbooks(tables) to oledb destination......i followed the instructions given in msdn but they r vague and do not help in achieving the result pls help me...

Use a Variable to Set the property of the work sheet($1,$2,etc) and Create the package.

Change that variable to Ursheet 1, sheet 2, sheet 3 while executing it...|||Thanks Buddy(Anil) it worked...[:)]|||

Quote:

Originally Posted by ashwinkpes

Thanks Buddy(Anil) it worked...[:)]

Fine.you can post some alternatives if you have..