one additinal note here of what I did:

In order to be able to connect to the Excel File (Excel.xls the sample that has column names) I had to delete the...

There is something still missing in this article. Can you please provide a step by step how you configure the Excel destination?

I created an Excel file and connected to...

So you mean that first I connect to the sample file in the Excel Destination and then change to the variable?

and when I change to variable it will not ask...

ok, you are right with all what you mentioned but the problem lies by assigning the Excel Destination in the DataFlow Task. When I assign the variablename it gives...

Hi,

What you mentioned is already clear. The place where we have problems in is the execute SQL Task in the Foreach loop and the Excel Destination in the DataFlow...

ah ok; I posted this link but the sample here is a little bit different.

Do you have a complete sample where you can e-mail it and check what is missing? Where the DataFlow is included as well. My problem is with the...

Thanks, but this means you didn't use the DataFlow Task. What you mentioned is only creating several files with one sheet or one file with several sheets. I...

SQL Server 2005

Check this link. It has a more detailed sample.

http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-into-dynamic_22.html