Listing Variables in the article:

ExcelTab

ExcelFileName

SubDataSet

obj_ListofGrouping

Grouping

SubGrouping

This is a situation of variables within variables. Grouping is used to define the ExcelFileName which is used in the Excel Connection Manager

Subgrouping is used to create the spreadsheet as:

"CREATE TABLE" + " " + "`"+@[User::SubGrouping] +"`"+ " " + "(

`Value1` NVARCHAR(35),

`Value2` NVARCHAR(40),

`Value3` NVARCHAR(200),

`Value4` NVARCHAR(50),

`Value5` NVARCHAR(15)

which is the expression within the ExcelTab variable

SubDataSet is the Select statement used to retrieve the data to populate the spreadsheets.

For me the simplest was to create the variables. Then add the components and then define each of the components.