I know how to do this using execute sql/script task but

i'm trying to find out if i can do this using data flow destinations.

Thanks a lot for your help.

I think i found the solution.

Rather strange.

Only some files have Sheet1 at the bottom.

I have made changes to all files to make sure they all...

Oops, i made change to parameter passing and now i get different error.

Here is the error message:

[Execute SQL Task] Error: Executing the query "Execute ImportExcelIntoSQL ?"

failed with the following...

Ok, it makes sense that you want to do it like this then.

My reason for disputing the use of the parameter is because surely your parameter has a ".xls" at...

Yes. If i pass the actual filename to variable @FileName directly, everything rocks!!

Problem is only if i try to automate the process.

Here is my task.

1. I have some excel files in a folder(each file has different columns).

2. Files are not the same all the time.

3. I need to import files into...