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

[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....

[guest]

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...

[ashwinkpes]

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

[guest]

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

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