可能多个原因:
1.in Excel Connection Manager,you can select Excel version(3.0,4.0,5.0,97-2005);
2.in Excel Source Editor,you can select Data Access Mode(Table name or view name variable,
sql command from variable);
3.assign the variable coming from foreach .xls filename .