hi, I am creating a data flow to load excel file into my sql server table. When i try to create Excel connection manager as the source and select the excel file sheet in "Name of the Excel Sheet" option, it's taking lot of time to pull up the tab. Is there any way i can quickly select the tab and create the excel connection manager as a source. Please advise... Thanks in advance...

you can chooose "data access mode" as SQL Command and then write queries like : SELECT * FROM [sheetName$] http://www.rad.pasfu.com