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 it the sample Excel file with column names. The excel destination was created successfully and I ran the package and it created the groups and subgroups successfully but without any records because all the records were filled in the sample excel file Excel.xls which is correct because that is the destination.

Here are the successful configuration

Excel connection Manager

Table or view

Sheet1$

After that I modified the Excell Destination to assign the variable SubGroup but it won't allow me and it gives me the following error: A Destination table name has not been provided. The variable subGroup is being assigned in the foreach loop correctly but it won't accept it. I looked a the variable SubGroup and by default it is empty.

Here are the failure configuration:

Excel connection Manager

Table or view from variable

user::subGroup

Am I missing anything here?

You help is appreciated. Thanks in advance.